CODEWITHSUNDEEP
sharepoint-2010ms-access-2010
1001b
1001b

Reputation: 265

Move Access web database to another Sharepoint Site

I have an Access web database (the out-of-the-box Project one) and plan to move to another Sharepoint site (a test server). I have done lots of googling and nothing comes up.

Upvotes: 0

Views: 2245

Answers (2)

mack
mack

Reputation: 2965

I was able to move my Access 2016 app to a new Sharepoint Site by saving it as a .app and uploading it to the new site.

I found this link to Microsoft's site helpful: Create an Access app package

Upvotes: 0

1001b
1001b

Reputation: 265

After some trials and errors, I figured out how to do that. First open the Access web db in Access client. Then go to Publish & Save, where you should see an option Save As Local Database. Then open the local database, again go to Publish & Save, you can choose to Publish to Access Services. A pane will appear to let you enter the URL of Sharepoint server and site name. If you have customizations or lots of lookups, there's a good possibility it will not publish. If that's the case, you just need to fix all the errors reported.

Upvotes: 2

Related Questions