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 ...
Forum Discussion
Where to? Mostly, what I laid out already.
OneDrive works for other types of files which do not require the type of sharing that Access accdbs require. (As mentioned, there are several good articles around the internet on the technical reasons.) You are using it as a single user? Put it on the local computer. If you need to use it on different computers at different locations, you could put a copy in OneDrive to download at those other locations, but running it should always be done locally to make life less hassle.
You call it a "calculator", which implies storing data is not the main focus.
OneDrive works for other types of files which do not require the type of sharing that Access accdbs require. (As mentioned, there are several good articles around the internet on the technical reasons.) You are using it as a single user? Put it on the local computer. If you need to use it on different computers at different locations, you could put a copy in OneDrive to download at those other locations, but running it should always be done locally to make life less hassle.
You call it a "calculator", which implies storing data is not the main focus.
No, it is manipulating data and presenting it in an appropriate form. It is, in principle, a very simple application.
I have disconnected the internet so it is now on a single, local computer but it problem remains. There are no locking or other hidden files.
Thank you for your patience.
I have disconnected the internet so it is now on a single, local computer but it problem remains. There are no locking or other hidden files.
Thank you for your patience.
- What problems, specifically, remain?
- As of last night, exactly the same. I have tried copying everything into a new database, I have checked all the settings, I have turner the internet off, all to no avail. It is really odd. I'm beginning to suspect a cloud upgrade fault (desperate!). Is anyone else getting the same problems?
- 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.
Weirdly, VBA edits can be saved.
- The same: it will not save an edit, because it says there is another user - but it is not one that I'm aware of. Someone fiddling around in the cloud, maybe. I've tried everything the Microsoft assistant suggested until it asked me to change some scary looking software that is way out of my skill set.