I uploaded an access database to SharePoint for file storage. Later I moved the file out of SharePoint and saved it to a network drive instead. Now every time I open the file it has a message across the top that says “Publish Changes” and invites me to Publish my changes to the SharePoint site. We no longer want to use the file in SharePoint and I can’t figure out how to stop getting that message. The file seems to be interminably linked to SharePoint now. With other file types I could do a “save as” and create another copy of the file but this does not work with Access. I am using Access 2007. Thanks.
Blue Feather – What you suggest is not at all a bad idea and one I’ve thought about. But this is a large and complicated database (no, it wasn’t my choice to put it in Access) with many objects and multiple modules. What you suggest would take a few hours at least. We may have to resort to the method you suggest, but I was really looking/hoping for a more straight-foward approach. (For instance, “Duh, delete the document from the SharePoint drafts folder.” Except that doesn’t apply.)
You could create a new blank database on your computer and then import everything from the SharePoint database into the new one.
If the problem persists, start again with another new blank database, this time importing one object at a time (table, query, form, etc.). Close the database after each such import, then re-open it. If the problem occurs again, you will know which object is associated with it. Just don’t import that one on the next try.
That may or may not solve the problem but it seems worth the effort doesn’t it?
on: 1st February 11