Hi, How would i go about creating multi user access to a database file? So 2 users can access it at the same time. I have a shared hard drive where both users could access it. I don't want a login form, just to be able to update data and see the changes on both machines in real time. Thanks
Question Multi User Access, Ms access 2007
- Thread starter waq963
- Start date
Rabbie
Super Moderator
- Local time
- Today, 08:32
- Joined
- Jul 10, 2007
- Messages
- 5,906
Access is a multi user system so no problems there. Your best way would be to split the DB into FrontEnd/BackEnd. The Back End should contain the tables and the Front End everything else. Each user should have their own copy of the FE linked to a single copy of the Back End.
See this link for more advice
See this link for more advice
