I have an Access data base that resides on our server and until we had a system problem that caused a global re-install from backup, any amount of users could be in the same database at once. Now only one user can have it open and if anyone else tries to open it they get a massage that the file is already in use (Error 3045). I looked under options and the shared box is checked.
Multiple users?
- Thread starter BBeck
- Start date
boblarson
Smeghead
- Local time
- Yesterday, 18:47
- Joined
- Jan 12, 2001
- Messages
- 32,025
1. If you have a database that has multiple users, you NEED to split it to a frontend/backend.
2. The backend (tables only) would reside on the server.
3. The Frontend would be a copy of the frontend on EACH user's machine.
See here for more about splitting your database.
Also, just so you know - if you run a single mdb/accdb file from a network location with multiple users, it isn't a matter of IF it will corrupt, just a matter of WHEN it will.
2. The backend (tables only) would reside on the server.
3. The Frontend would be a copy of the frontend on EACH user's machine.
See here for more about splitting your database.
Also, just so you know - if you run a single mdb/accdb file from a network location with multiple users, it isn't a matter of IF it will corrupt, just a matter of WHEN it will.
Similar threads
- Deleted Bruce 182381
- General
