G said:
Hi.
I have place an access database on a server folder.
However no more then one person can access it.
I have gone to TOOLS OPTIONS and in the advanced tab selected SHARED
setting.
plz help as i would like to have several people accessing it and
entering data into it.
thanks
As Rick pointed out each of them will need full permissions to the
directory where it is located. You also want to make sure the users are not
opening it exclusively.
Next you need to decide the split. What parts of the database will be
on the "server" and will be called the Back end database from now on and
which parts will be on each user's machine and will be called the front
ends. The back end should hold all data that is shared and may be changed
by the users. It should also contain all or most data that more than one
user will need access to and may be changed by you from time to time. Most
other data that does not change or that will only be used by that particular
user should be on the Back end databases on the users machines.
Access works best if it does not need to move a lot of information over
the LAN which means static data is best kept on the front end databases.
Also kept on the front end machines will be most forms, reports queries etc.
This will allow the whole system to work faster and in some cases allow for
customization of some forms reports etc.
This may seem like a lot of work and off the point of the question you
were asking, but it is very important that this part of the job be done
first and right.
Splitting a database can be a big job, but done right everyone will
thank you and wonder how they did their jobs without it.
Note: back ups become more important here. If you LAN does not support
automatic backups you should provide a method of backing up the data, even
if that means you do it manually.
