We have a database that is used by 5+ users all the time. The problem that I'm experiencing is that I cannot make changes to any forms, macros or reports when someone else is in the database. Is there any way around this? I don't want to have to ask the users to get out of the db every time something needs to be created or modified. I've even tried working out of a copy of the db and then trying to export the objects only to get the same message.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
'You do not have exclusive access ...' message 1
- Thread starter kangj
- Start date
-
1
- #2
No can do, have to get them out, or split up the db and give them front ends to the data. Then you can modify the master, and have it automatically distributed to clients the next time they open the db. This is not an easy thing to set up though, so if you're not extremely comfortable with VBA and the like, I wouldn't advise it.
Joe Miller
joe.miller@flotech.net
Joe Miller
joe.miller@flotech.net
- Status
Similar threads
- Locked
- Question
- Locked
- Question