Forum Discussion
Move Existing Sharepoint Linked Database to a different 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.
I am working through this now, seems to be going ok, ill update you on progress. Thanks again.