MS ACCESS on OneDrive

Question

I have an Access .accdb file stored on One Drive.  I normally access it with my desktop PC.

I tried to open the file today with my laptop but was unsuccessful.

When I then tried using my desktop PC, a yellow warning appeared telling me to Save to SharePoint Site and I could not open the file.

I do not have a share point and I have not been able to open the file.

What can I do to access the file?

Thanks

John

Answer 1

This is a FAQ. In short: don't do it.

https://www.devhut.net/2016/09/24/access-back-end-location-wan-online-server-onedrive-dropbox/

Why DropBox, OneDrive and Offline Folders will corrupt your Access database

Answer 2

If you want to use OneDrive to make an Access database portable, the only realistic way this can be done is to download the back end file to the local machine, and then upload it back to OneDrive at the end of each session.  In effect OneDrive is being used as a back-up location.  This means of course that the database is restricted to one concurrent user, and cannot be used in a multi-user environment in the same way that can be done with a back end located on a server to which all users have access through a good quality wired local area network.

I regularly use OneDrive in this way for my personal finance databases and similar.  Like you I mostly use a desktop machine for this, but when travelling download and upload the back end to and from a laptop.  To facilitate this I include the means to easily restore and back-up the back end via each front end file.  This includes the means to back-up to a local portable hard drive and to OneDrive, so two up to date back-up files of each back end are always available, as a safeguard against one  of them becoming corrupted.  You can find an example of this in BakupDemo.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

As well as the facility to create single local and online back-ups  this little demo file also includes the means to create multiple dated local back-ups of the back end.