Share via

Microsoft Access 2016: how to recover lost data?

Anonymous
2021-11-04T10:56:37+00:00

A database with no backups has been corrupted pressumbly as when dowloading it from sharepoint and attempting to open it up it gives me msyscompact error with the error code -1907, then description I do not have permission to access the tables, while what was uploaded was originally mine and no security on that database was set in place, so anyone could access it. Does anyone know how I can recover lost data or any data that was on this database?

Microsoft 365 and Office | Access | For business | 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
    2021-11-04T12:00:47+00:00

    Have you tried creating a new blank db and importing your tables?

    Doesn't SharePoint have version histories of the file that you could simply restore?

    I do hope after this, you will stop using SharePoint to share an Access database as it is a well known no-no and also implement regular backups as corruption is a real possibility.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-04T12:50:11+00:00

    There is no file history, it was the only file. I tried importing but it doesn't give a lot of data back, I was wondering if there was another solution to regain more data.

    Is it better to share a database on a local file server or my personal onedrive?

    1 person found this answer helpful.
    0 comments
  2. George Hepworth 22,765 Reputation points Volunteer Moderator
    2021-11-04T13:24:48+00:00

    PMFJI:

    OneDrive is just as dangerous as SharePoint in this situtation.

    Place the Back End accdb in a shared folder on your network. Place the Front End accdb on your own computer's hard drive.

    If you don't recognize the terms, "Back End" and "Front End", take a break from working with this relational database application and invest some time in learninghow professional, experienced Access developers work.

    0 comments