Share via

Un Link my Access 2010 database from SharePoint Access Services

Anonymous
2011-05-15T18:19:21+00:00

I've published my web database to Access Services in SharePoint.  Now I'd like to completed un link my Access database to SharePoint because I want to work on it locally a few days and then republish it to a different site.  How do I completely un link it from Access Services?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2011-05-16T18:31:35+00:00

    Hi Joel,

    After looking into this a bit further, I don’t know of an easy way to disassociate your local database from the SharePoint site (most likely because all of the tables have now become SharePoint lists).  However, when you published your application, Access should have made a backup of your database before doing so, which is not associated with SharePoint.

    If you don’t have the backup or you have made several changes since then, you could try the following:

    1.      Use the “Open With Access” option from your Access Web application and then choose to save a local copy.  This will then save a .ACCDW file to your machine.

    2.      Open this file in Access.

    3.      Then go to the File menu and choose the “Save Database As” option.  This will then allow you to create an .ACCDB file for this database on your machine.

    4.      Create a new Access Web database.

    5.      Open this new database and go to the External Data tab and in the Import section click on Access.

    6.      Browse to the .ACCDB file that you saved in step 3 and import all of the objects from that database into this database.  You should then see all of your objects in the navigation pane and your tables will show up as SharePoint Lists.

    7.      Highlight one of these linked SharePoint lists and do a copy and paste.  When you do the paste, you should see a “Paste Table As” dialog.  In this dialog, choose the option to paste the table as “Structure and Data (Local table)”.  This will then create a local web table.  Do this for each of your linked SharePoint lists.

    8.      Make note of your original table names and then delete the linked SharePoint lists from your application.

    9.      Rename your local tables so that they have the same names as your original tables.

    At this point your application should now no longer be associated with a specific SharePoint server and you should be able to publish it to a different server.

    Best Regards,

    Nathan Ost

    Microsoft Online Community Support

    1 person found this answer helpful.
    0 comments

16 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-10T19:06:19+00:00

    I found a much better solution than any offered up here.

    http://www.access-programmers.co.uk/forums/showthread.php?t=178074

    for those unwilling/unable to follow the link, run the following single line of code (as is) in the VBA editor:

    currentdb.Properties.Delete("PublishURL")

    This will remove the currentdb property "PublishURL" which holds the address of the published location on sharepoint, thus completely breaking the connection to that sharepoint server.

    Additionally, you may want to delete the SharePointSiteMRU property:

    currentdb.Properties.Delete("SharePointSiteMRU")

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2013-02-28T23:51:54+00:00

    You don't have to do all that song and dance.

    The feature to un-hook and UN-publish the Access Application from the web site is built in, and you don't have to resort to a manual process.

    The feature is simple:

    You go file->Save and Publish

    The option you then choose is

    Save as local database.

    The above creates a new local un-published and un-connected copy of your database (including data tables) for you.

    I mean, here is a screen shot:

    https://am4ohg.sn2.livefilestore.com/y1p8g7wdVYYzjXXZ_WIxz9_vYNwgbTRyHNJj5R79HXGv3PROZHEXf8ExfswxPNQDIilcWD9-lD0ZjUjvQZvyikPlnxL1yCwhR3z/local.png

    This is simple file option available in Access to UN-publish and UN-connect your application from the web site. I should note we are talking about a 2010 web application here.

    So you are just having a bad day, and we quite much need a surgical team to remove the foots people are placing in their mouths here.

    Best Regards,

    Albert D. Kallal (Access MVP)

    Edmonton, Alberta Canada

    2 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-02-28T21:21:07+00:00

    The only way I was able to unlink the database from SharePoint was by copying all my stuff (Tables, queries, forms, reports …etc..) by following the process below.  Don’t know what MS was thinking when they  build it that it was never going to be unlink from SharePoint. There should be an easier way where you just disabling or Enabling the option.  Maybe Microsoft will get it next time. Hope this helps I was looking for a quicker solution than the one I found out but was not able to find it.

    1.      Open New Database

    2.      Go to External Data Tab

    3.      Click on Access (Import Access Database)

    4.      You than get a New Screen, click on Browse.., and select your database you want to unlink from Sharepoint

    5.      Select Import Tables, queries, forms, reports …etc..(It should be the default option)

    6.      Click Ok.

    7.      New Window shows with several tabs. Now go through each of the tab and click on Select All for each of the tabs(Tables, queries, forms, reports …etc..)

    8.      Click Ok.

    9.      Save your database as whatever you want.  You have now a new copy or your database that is no longer link to SharePoint

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2015-08-31T08:35:09+00:00

    Even if the thread is quite old, here is an answer I found from here

    Apply this code

    CurrentDb.Properties.Delete ("PublishURL")

    Sebastien

    1 person found this answer helpful.
    0 comments