Access 2010 Test Lock File
Hi Experts,
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.
Thanks.
Bob C.
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.
Thanks.
Bob C.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Jeffery,
The ability to use a SharePoint Server is not available to us. we are small non-profit organization so 'paying' for a service is not viable.
Thanks for the suggestion though.
Bob C.
The ability to use a SharePoint Server is not available to us. we are small non-profit organization so 'paying' for a service is not viable.
Thanks for the suggestion though.
Bob C.
ASKER
Hi Jim,
As part of this process I currently click a button on Form A that opens Form B and closes Form A. Form A doesn't access a Database but form B does. Eventually I close Form B and open Form A again.
I would like to 'hide' Form A instead of closing it when I open Form B which will allow me to pass data between an unbound field on Form A and then 'un-hide' Form A when I close Form B.
I don't know the syntax to 'hide' and 'un-hide' Form A (assuming it can be done) There isn't a .visible Property for a Form Object.
Thanks.
Bob C.
As part of this process I currently click a button on Form A that opens Form B and closes Form A. Form A doesn't access a Database but form B does. Eventually I close Form B and open Form A again.
I would like to 'hide' Form A instead of closing it when I open Form B which will allow me to pass data between an unbound field on Form A and then 'un-hide' Form A when I close Form B.
I don't know the syntax to 'hide' and 'un-hide' Form A (assuming it can be done) There isn't a .visible Property for a Form Object.
Thanks.
Bob C.
ASKER
Thanks for the information.
Might SharePoint be a better option in this case?