Allow more than one user on a database

[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

 

[Gina Whipp]

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

 

[Arvin Meyer [MVP]]

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).

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

 

[Gina Whipp]

Arvin,

Thanks, I added that to my collection!

--
Gina Whipp

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

http://www.regina-whipp.com/index_files/TipList.htm