Access 2010 Test Lock File
Posted on 2015-02-12
I have multiple Users of an Access Application using their laptops in their homes to manage data located in a Back End Database (BEDB) in Dropbox. Due to the way Dropbox works, if more than one User accesses the data base at a time updates are not processed correctly.
To manage this I want to stop more than one User connecting at a time. My idea is for the application to check if someone is currently using it and if so advise them so they don't connect.
When a User starts up the application it doesn't immediately connect to the BEDB. I would like the application to:
- Test to see if a file exists in the BEDB Folder and if it does display a message. to the User.
- If the file doesn't exist I want to create one.
How do I?
- Test for the existence of a specific file. e.g. Open.txt
- Create the file 'Open.txt' if it doesn't exit.
PS: If there is a better solution to achieving this I'd like to hear about it.