Connecting to SQL server

[Guest]

Connecting Access to SQL tables is simple but is it wise? With say 40/50
users using an Access runtime FE should a prudent database developer be
connecting directly to tables. What should be the strategy in multi-user
environment data entry and modification??

There must be some documentation around on this subject comments and links
will be thankfully recieved.

john bell

 

[Rick Brandt]

Connecting Access to SQL tables is simple but is it wise? With say
40/50 users using an Access runtime FE should a prudent database
developer be connecting directly to tables. What should be the
strategy in multi-user environment data entry and modification??

There must be some documentation around on this subject comments and
links will be thankfully recieved.

john bell

As in any good client server database application you want to concentrate on
pulling the least amount of data at a time. Connecting directly to tables in
not an issue as long as you do so in a manner that will not drag tons of records
over the LAN unnecessarily.

An Access front end to a SQL Server back end with 40/50 users is barely
scratching the surface. I have a few hundred users connecting to half a dozen
databases on three or four servers with no problems.

 

[Guest]

Thank you Rick for your comments
john bell

As in any good client server database application you want to concentrate on
pulling the least amount of data at a time. Connecting directly to tables in
not an issue as long as you do so in a manner that will not drag tons of records
over the LAN unnecessarily.

An Access front end to a SQL Server back end with 40/50 users is barely
scratching the surface. I have a few hundred users connecting to half a dozen
databases on three or four servers with no problems.

 

[Roger Carlson]

A good reference for creating Access apps against a SQL Server database is:
Microsoft Access Developer's Guide to SQL Server by Andy Baron, Mary Chipman


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks Rodger for the referrance.

johnb