Results 1 to 2 of 2
  1. #1
    Johnmad86 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jul 2013
    Posts
    1

    extract tables from deleted Sharepoint database

    Hi,



    Hopefully someone can help as Microsoft have cancelled our Sharepoint subscription (as they no longer provide O365 small business). They have also deleted our Sharpoint database which was hosted with them

    We have backup files in *.accdb format (approx 9MB), but its impossible to open these as the database tries to contact sharepoint when its opened.

    the database is opened in read-only, but none of the tables can be viewed.

    We're also unable to copy/export the tables as it states:

    "The Database '' cannot be opened in exclusive mode because it contains links in cached mode"

    Needless to say, this is our entire business and critical that we can access the data.

    Does anyone know if its possible to export the tables from the backup database file we have? all we need are the .csv of the tables, we can re-create the database from these if we can access them.

    Thanks in advance

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Have you tried to hold the shift key down while opening the database, thereby bypassing all open events?
    Have you tried opening a second database and linking to/importing those tables?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 07-14-2017, 05:37 AM
  2. Replies: 0
    Last Post: 05-06-2017, 01:27 AM
  3. Replies: 3
    Last Post: 10-19-2013, 08:23 PM
  4. Filtering on multiple tables/queries then extract to csv
    By GraemeG in forum Import/Export Data
    Replies: 7
    Last Post: 10-18-2012, 03:34 PM
  5. delete query produce #deleted in all deleted values
    By learning_graccess in forum Queries
    Replies: 2
    Last Post: 03-31-2012, 07:20 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums