Forum Discussion
Move Existing Sharepoint Linked Database to a different Sharepoint Site
I am working through this now, seems to be going ok, ill update you on progress. Thanks again.
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.
Thanks again for your help. I exported the tables to the new Sharepoint site, then I deleted the data and imported the tables to the new database. I was able to have the 2 x different company Sharpoint sites open on the same PC so all worked ok. The only tables that did not export were tables built from subforms.