Allow more than one user on a database

  • Thread starter Thread starter Rochelle
  • Start date Start date
R

Rochelle

I have created a database and posted it to our network where no more than 3
people will be using it at a time. Currently I can only get one user on the
database at a time.

I'm using Access 2007. How to I allow more than one user to enter
information (not make changes) into the database. (the folder where the
database is located, allows for additions and deletions).

Thank you
 
Rochelle,

Sounds like you put the entire database on the Server. You should split it
and put the Front End on each persons workstation. Have a look at...

http://www.members.shaw.ca/AlbertKallal/Articles/split/

http://allenbrowne.com/ser-01.html

If each user needs Access you can install the Runtime...

http://www.microsoft.com/downloads/...d9-9dc6-4b38-9fa6-2c745a175aed&displaylang=en

To keep those Front Ends up to date with any changes you might make...

http://www.autofeupdater.com/

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Rochelle said:
I have created a database and posted it to our network where no more than 3
people will be using it at a time. Currently I can only get one user on
the
database at a time.

I'm using Access 2007. How to I allow more than one user to enter
information (not make changes) into the database. (the folder where the
database is located, allows for additions and deletions).
Click to expand...

In addition to Gina's remarks, you may also want to take a look at MVP Ton
Wickerath's article:

http://www.accessmvp.com/TWickerath/articles/multiuser.htm
 
Back
Top