[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