[AccessD] Connecting Access to SQL tables

Doris Manning mikedorism at verizon.net
Fri Nov 17 08:43:48 CST 2006


A prudent database developer would NEVER EVER allow users to connect
directly to the tables.  Everything should be done through stored
procedures.  

Start by reading Rick Dobson's "SQL Server with Access 2000".  Here is a
link to his website http://www.programmingmsaccess.com/

Doris Manning

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Johncliviger at aol.com
Sent: Friday, November 17, 2006 9:14 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Connecting Access to SQL tables

Salutations
 
 I am proposing to connect Access FE to SQL 2000 tables  which 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  where data is being  entered and 
modified??

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

TIA
johnc

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list