CODEWITHSUNDEEP
ms-accessvbasharepoint-2007ms-access-2016
Tom36
Tom36

Reputation: 152

Share an access Database on Sharepoint

I have created quite a large Access 2016 db. It is now ready to share with the business and needs to be put onto SharePoint. I've tried just uploading the file to a SharePoint document library, however users cannot edit the database (there is a lot of VBA code that runs SQL commands that write data input by users into the database).

Is there a way to share the database that allows users to open it from SharePoint and let the VBA write to the database/tables?

Upvotes: 0

Views: 1097

Answers (1)

Gustav
Gustav

Reputation: 55816

That is not possible as SharePoint isn't an SMB fileshare, neither is OneDrive, DropBox, etc.

The SMB fileshare is offered by a Windows Server or a Linux box with Samba installed.

Upvotes: 1

Related Questions