Multiple users issue

[round]

Hello all,

I have an mdb that only one user can have open at a time, but the default open is set to shared.

Any Ideas?

Many Thanks

 

[The_Doc_Man]

If you are on a version of Access before AC2007: Search this forum for "Securing a Database" and "Workgroup Security." I suspect that what has happened is that your users have the default SYSTEM.MDW because the database hasn't been properly secured. In such databases, every user comes in as SYSTEM, which by default has the permission to do an OpenExclusive on the database.

If you secure the database properly, you could restrict your non-adminstrator users to have only OpenShared permission on the database object, and that would solve much of your problem right there.

If you are on Ac2007, I must defer to others. Haven't played with that version yet.

 

[round]

Thanks Doc i have looked into the mentioned items and I got a little lost.

As I see it I will need to add all users explicitly?? This could take some time. Is there not a way that all users who access the mdb come in as a standard user?

I tried the work group security wizard which created an mdw file but then I was was unable to open the db again. I obviously did something wrong but not sure what??

 

[round]

Once the mdw file is created how can the db be moved because I get an error saying the file can't be located.