Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

limitations of using a split access database on onedrive

Copper Contributor

What are the limitations of using a split access database with the backend loaded to oneDrive?


2 Replies



Okay, a fuller answer might be useful.

Here's a link to a very good explanation

Rather than rehash it again, I'll recommend Daniel's article which explains it all.

That said, if you are looking to get around the recommendation by putting only the back end on OneDrive, the arguments against that are pretty much the same. You are risking data loss and data corruption. It's not guaranteed to happen, but it's significantly more likely to happen. If your data is worth putting into a relational database application, then it's also worth protecting as much as possible.


Here's what Microsoft has to say on the subject. I highlighted the relevant sentences.

Warning    Although you can save an Access database file to OneDrive or a SharePoint document library, we recommend that you avoid opening an Access database from these locations. The file may be downloaded locally for editing and then uploaded again once you save your changes to SharePoint. If more than one person opens the Access database from SharePoint, multiple copies of the database may get created and some unexpected behaviors may occur. This recommendation applies to all types of Access files including a single database, a split database, and the .accdb, .accdc, .accde, and .accdr file formats. For more information on deploying Access, see Deploy an Access application.