Sharing Access

  • Thread starter Thread starter Deb Roberts
  • Start date Start date
D

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
 
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
 
It would be best to split the database so each user has a front end on
their machine and the data only is located on the shared drive.

It may not be needed with only a few users. Depending one what is going
on, there may be other steps necessary to make sure things work smoothly.

How often is data changed or added? Who does the changes? Will two
people be making changes at the same time? Will someone want to make
changes to the design of the database while someone else may have it open?
How comfortable are you with everyone having the ability to make changes?
 
Back
Top