Access Front End, SQL Back End

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Greg La Due - 13 Sep 2004 19:23 GMT

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.

Signature

Gregory M. La Due
Twin Tiers Technologies, Inc.

Reply to this Message

Mary Chipman - 14 Sep 2004 20:03 GMT

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

>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.

Reply to this Message

Greg La Due - 14 Sep 2004 21:11 GMT

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

Gregory La Due

> Work in disconnected mode, where data access is done read-only, and
> updates are posted back via stored procedures. Fetch only required
[quoted text clipped - 10 lines]
> >the front end would produce the fastest results when modifying and adding
> >records.

Reply to this Message