Saving Access file to SharePoint with code

Question

I have a standard Access Database saved on SharePoint. My organization uses SharePoint, but I only have standard access to areas particular to my department. (I cannot create or link a web based database to SharePoint with my access level.)

In my Access file, I have a form that saves its data to the table - locally - when I hit the submit button.

The ribbon below appears and if clicked, transfers the whole Access file to the SharePoint storage location, but only if that button is clicked. Otherwise it only saves a local copy.

Is there a way I can automate a network/SharePoint save location in code so the user doesn't have to remember to press that button?

BR89 · Accepted Answer · 2017-05-12 19:02:54Z

1

After a week of trying to figure this out - there's a simpler solution.

Save the file as an exectuable - accde instead of accdb. Not only does it not ask to run the macros every time, but it saves automatically to SharePoint.

Hope this helps someone else in the future.

answered May 12, 2017 at 19:02

BR89

7161 gold badge6 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving Access file to SharePoint with code

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related