Access Front End, SQL Back End

[Greg La Due]

Using Access XP as a front end, SQL 2000 as the back end with about 50
tables and a VPN as the connection between the two. What configuration of
the front end would produce the fastest results when modifying and adding
records.

 

[Mary Chipman]

Work in disconnected mode, where data access is done read-only, and
updates are posted back via stored procedures. Fetch only required
data, and make use of local tables for caching data. Use pass-through
queries instead of linked tables. You will need to handle concurrency
conflicts manually.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

 

[Greg La Due]

Thank You for the information. I thought as much, but I was hoping for
something more simple.

Gregory La Due