Hi
I have just created a database for supply and employee tracking needs. I have the some forms that need to be used by other people in the office but I would like to continue to work on the database at the same time. This is the first Access database that I have made so it is very simple in design.
Full Version: Two Users at once
Hi,
Welcome to UA forums.
did you split the db in front end and back end set up.
You should do that to provide multi user environment.
Check this:
split faq's
for more info.
HTH
Good luck
Welcome to UA forums.
did you split the db in front end and back end set up.
You should do that to provide multi user environment.
Check this:
split faq's
for more info.
HTH
Good luck
Welcome to Utter Access! 
Split. Your. Database.
The best and most stable setup for a multi-user access database is for a back end (with all your tables) to reside on a network, and for each user to have a copy of the front end (with all the forms, reports, and queries) on their own PC.
In addition to the "production version" that each user has, you can then also keep a prototype version, in which you can continue modifying and creating new forms and reports. Whenever necessary, you then roll out a new version of the front end to the users.
-AJ
Split. Your. Database.
The best and most stable setup for a multi-user access database is for a back end (with all your tables) to reside on a network, and for each user to have a copy of the front end (with all the forms, reports, and queries) on their own PC.
In addition to the "production version" that each user has, you can then also keep a prototype version, in which you can continue modifying and creating new forms and reports. Whenever necessary, you then roll out a new version of the front end to the users.
-AJ
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.