Forum Discussion
Move Existing Sharepoint Linked Database to a different Sharepoint Site
George, thanks for the prompt response.
I have done the following -
- Made a copy of the Access file.
- Created the new Sharepoint site.
I have been trying to export the Access file to the new Sharepoint site but i get the error message that i need to review the 'Trust Settings'. To be honest i am struggling because i haven't an idea how i should be going about this.
I will have a go at the steps above and see how it goes. Thanks
Trust settings refer to the location of the accdb on your computer. You have to designate the folder where the Front End accdb is stored as a Trusted Location. You must have done that already for the existing deployment. Take a look at how that was done.
You will not actually export the Access file itself to the new SharePoint site. You will only link it to the new SharePoint lists there.
When you do that, a dialog will open asking you for the location of the SharePoint lists. Enter the URL and select the lists/tables. This is assuming that you have already created the lists needed for the subsidiary on their SharePoint site.
Ok, at the moment the copied access file is still linked to the original Sharepoint lists. When you say create new sharepoint lists in the new sharepoint site, do you have to do this manually or is there a way to copy the lists between sites? (i am currently searching the web for methodology)
I have never tried to copy SP lists from one site to another, so I'm unsure what to suggest with regard to that. I somewhat doubt that is an easy thing to do.
However, perhaps one way would be try to export the existing linked SP's to the new subsidiary site.
Make backups first, of course. See if that accomplishes the goal. You may have to also relink this accdb to the new SP lists.
I've not tried this, but it seems like it ought to work. Of course, you'll also want to avoid moving the data.
Years ago, I wrote a series of blog articles, when Access with SP lists were relatively new. Maybe there's some relevant content there.
https://www.gpcdata.com/search?q=sharepoint
check out the articles on migrating data and tables.
