[AccessD] Connecting Access to SQL tables

John,

All I can tell you is that I have done this before, with no problems.  I
had linked tables in my FE, to the SQL database.  Worked Great.

Regards,

Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com

RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
21231-3305

410-537-6098 direct | 410-276-2136 fax | www.rtkl.com

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