Why can't I share my Enviro Data database using OneDrive or SharePoint?

The answer below from Microsoft (emphasis added). Do not use OneDrive or SharePoint to share an Access database as this is not supported. If you need to share your database use a local server, SQL Server database, or Azure SQL database.

The following is from Microsoft.

Want to combine and enhance both Access and SharePoint? To do so, you can import, link, or move data between them. Importing creates a copy of the SharePoint list in an Access database. Linking connects to data in another program, so that you can view and edit the latest data both in SharePoint and Access. Moving creates lists on the SharePoint site that remain linked to tables in your database and maintains their relationships. [SharePoint Lists have a very limit capacity and will not support an Enviro Data database.]

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 Import, link, or move data to SharePoint.

For an overview on sharing a single back-end Enviro Data database locally or a remote desktop, on OneDrive/SharePoint (not recommended), or on a sever, please see Ways to share an Access desktop database

#93Edited 3 months ago