Allow only one User connection to shared MS Access Database
Posted on 2007-07-27
Is there anyway to configure an access database so that it can only be opened by only one person at a time?
I know of the options in tools->options->advanced and this does seem to successfully prevent editing of tables once they are opened by another user. However, it doesn't seem to stop changes being submitted from forms?
I really want to lock them out completely, as that way there is no ambiguity.
I have tried setting up a shortcut with the "\excl" switch on the end, but this still allows access by another user, if they open the database directly by double clicking on the file.
Can anyone offer any advice, or is this something which is just not possible without some coding effort?
The users are using a mix of MS Access 2000 and 2003, but I think it is originally an Access 2000 database.