Access 2007: cannot make accde "exclusive"

[gunny3000]

Hi all,

I have developed my DB. I want to lock-down the DB to users, and, make the file exclusive to avoid duplication of records and other associated errors.

I have gone into the 'Advanced' 'Access Options' and checked the 'Default open mode = Exclusive'. Alas, this does not work. I do not want to rely on my users opening the DB by using the arrow icon on the Open button - they will probably double-click the ACCDE icon anyway!

Any help always appreciated.

 

[DCrake]

Is your database split? Opening exclusive means as it suggests opeing the Access database. If you have linked tables to a different back end then it is this that needs opening exclusively, not the fornt end.
If each user has a copy of the front end one their machines then they will be opening it exclusively but the back end is in a shared environment.

To get around this issue you can place a table in your back end that has a boolean field that is flagged as true when a user opens the front end, and back to false when they log out.

If the flag is true then this means that someone else is already in and it will not let them open the database.

There are more options that this one this is just the easiest one I could think of.