Single use DB

[FoFa]

Anyone know how to make s Access DB single use?
i mean only allow a single users at a time, without changing each persons Access to Exclusive from Shared? So exclusive at the DB level?

 

[Access_guy49]

I have been informed that you can open a database exclusivly using the command line

DatabaseName and "/excl"

 

[SOS]

Opening a database exclusively is not the same as only letting one person in.

 

[FoFa]

I'll give that a try.
Thanks

 

[ghudson]

Opening a database exclusively is not the same as only letting one person in.

SOS: Technically... How is it not the same?

I suspect the poster is having a problem that should be resolved instead of only letting one user in at a time.

 

[FoFa]

Oh the problem should be resolved, I pointed out many issues with their design, and was told, no money to fix, we need to let only one person in at a time.
Sometimes we are just stuck with it.....