Forum Discussion
Access to Access
I am a single user using OneDrive and 365. All of a sudden Access says I can't save edits because there is another user. There isn't. Occasionally the file locking file can be seen in Explorer but I ...
What problems, specifically, remain?
Sorry, specifically: when I try to save an edit of a form, it says there is another user and so my changes will not be saved. I have tried deleting the lock file when it takes a longer than usual time to delete itself.
- Please do not try to delete the lock file, i.e. the laccdb, except under one significant condition mentioned below. The lock file should be totally under the control of Access and deleting it with its corresponding accdb open would be a problem. The good news is that you should not even be able to delete it while its parent accdb is still open, so that's not highly likely.
Access creates it when the first user opens the accdb. Access closes it when the last active user closes it. That ensures when the shared accdb (in this case, that should be only the BE, by the way) is in use, Access can manage reads/writes to DATA. It also ensures that users can't change other objects like forms and VBA when more than one user has it open.
The only time I can see deleting an laccdb would be if the accdb crashed, or was closed abnormally, leaving the laccdb open with no parent accdb open. You might even have to reboot the computer to be able to delete it in that situation.
In other words, leave the laccdb alone except for dire problems.OK, I will leave well alone.
Weirdly, VBA edits can be saved.
No, there is something else going on then.
If you can't save records, but can save changes to VBA, there is some other issue at work.
Can you show a screenshot of the error message saying you can not save changes to records?
- Well, I am completely confused. I removed a bit of innocuous vba code and now it works sometimes but not others. The folder still self-corrected to 'read only'. I will try to live with it, get some commercial accounts software and someone else to do the accounts!
Thank you again for your help.