Access Front End, SQL Back End

  • Thread starter Thread starter Greg La Due
  • Start date Start date
G

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.
 
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
 
Thank You for the information. I thought as much, but I was hoping for
something more simple.

Gregory La Due
 
Back
Top