I would like the users of my database to all be able to access it at any one time - I have set up user log ons for all those concerned but when one of us tries to get in when someone else is in it says it is locked?
Multi user issue
- Thread starter baba78
- Start date
From Access 2000 onwards you cannot have more than one user editing the design of the database at one time. This means that you should be OK if people or logging in and just viewing/adding/editing records, but as soon as one user goes into an object in design view or looks at the VB code they'll lock other users out. And the other users will stay locked out until the user making changes closes the database, not just until they've stopped making changes.
Len Boorman
Back in gainfull employme
- Local time
- Today, 00:30
- Joined
- Mar 23, 2000
- Messages
- 1,930
There could be a number of reasons.
1) are your users opening the database "exclusively". That will lock out all other users
2) Under design conditions you generate an exclusive open database
3) If you are looking at a record then it is possible that lock all records is being set
Suspect 1 or 2 as main culprits
L
1) are your users opening the database "exclusively". That will lock out all other users
2) Under design conditions you generate an exclusive open database
3) If you are looking at a record then it is possible that lock all records is being set
Suspect 1 or 2 as main culprits
L
- Split the database and give each user his/her own front end.
- Split the database and give each user his/her own front end.
- Split the database and give each user his/her own front end.
Seriously though, you are heading for a corruption nightmare if you don't.
MSAccessRookie
AWF VIP
- Local time
- Yesterday, 19:30
- Joined
- May 2, 2008
- Messages
- 3,428
I vote for option 2.
- Split the database and give each user his/her own front end.
- Split the database and give each user his/her own front end.
- Split the database and give each user his/her own front end.
Seriously though, you are heading for a corruption nightmare if you don't.
Some people find that number 3 works better for them, while others (Rookies like me, for instance), often grab the first solution that comes along. No matter, we do agree about the corruption issue.
