Single User Access

[Kyrierat]

Hi All,

This seems a silly question as most people ask the opposite, but is it possible to restrict an Access database so only one person can use it at a time (a bit like other office documents do)?
I have about 10 users but I only want one user to be able to access the database at a time as my boss is worried about write conficts. I know there are ways rounds conflicts but my boss is insisting only one user so any help would be appreciated!

Thanks

[Delerna]

I think if you put the database into a common location and they all access that same file then when someone opens it a locking file will be created and that, will effectively stop others opening it for write access untill the first person closes it and the locking file gets deleted.
the locking file gets created and deleted automatically when you open and close the database