Question How to unpublish a database to Sharepoint

[swinster]

Hi all,

I have an Access 2007 DB that I will eventually publish to a SharePoint site for general use, however for the moment I'm just wanting to work on it locally.

As I have published the DB as a SharePoint file in the past it now continually asks me to re-publish the file. How can I disassociate the file from the SharePoint site?

Chris

 

[boblarson]

If I remember correctly, from what the Access Team told us, you can't. You would need to use a backup copy of the database prior to publishing.

 

[swinster]

Man that's rubbish.

 

[TJPoorman]

I know that this is a very old thread, but i recently found a way to remove the association between an Access DB and SharePoint without having to migrate everything to a new database and wanted to share.

Simply run the following line in the immediate window of the VBA Editor and you will no longer get the message box:

currentdb.Properties.Delete("PublishURL")