Ben Rebecca
asked on
Saving Access file to SharePoint with code
Hi EE Community,
New to the community and still pretty raw in Access. (I do have experience in Java/Android and Python, so I'm not completely clueless to all things!)
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?
Any SaveAs with a path designation would work. Thanks!
New to the community and still pretty raw in Access. (I do have experience in Java/Android and Python, so I'm not completely clueless to all things!)
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?
Any SaveAs with a path designation would work. Thanks!
PatHartman
Sorry, I don't have an answer to your question but Access really shouldn't be used this way. Are you aware that if two users open the database and each makes local changes, the second person saving will overwrite the first person's changes?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're living on the edge.
PS - the .accde is NOT an executable although the code is partially compiled and the source is removed to prevent changing.
PS - the .accde is NOT an executable although the code is partially compiled and the source is removed to prevent changing.
ASKER
Solved the problem