Sharing Access

[Deb Roberts]

I have created an Access XP database which will be shared by only 3 or 4
users.

The database will reside on a shared network drive. Is there any need to do
anything else to allow sharing of the file, or are the default sharing
settings adequate for such a small group of users??

Thanks & regards

Deb Roberts

 

[Van T. Dinh]

You should split the database to Front-End and Back-End. The Back-End
contains only the Tables and resides on a shared network drive. The
Front-End contains all other Access objects and each user should have a copy
of the Front-End on his/her desktop.

Check Access Help on splitting a database and Tony Toews' article:

http://www.granite.ab.ca/access/splitapp.htm