Access 2013 is using Microsoft SharePoint 2013 to host the front end of the app and Microsoft SQL Server 2012 as its data storage technology. As a result, each item inside access app table is NOT list item but a database entry. If you delete an entry or massed up the content of the table, there is no easy way to restore from UI. In this blog, I will explain how to restore the Access app based on the Access 2013 architecture.
Now you might be able to identify the recover strategy already. If user request to backup or restore Access tables, we could follow the below procedure.
- Identify the Access App database by click “File” from Access client as described from previous blog
- Identify the tables inside the database like “Access. Employee”
- Restore the table form previous desired time
Please note, there might be macro created by end users that will be translated into database trigger as described in previous blog. You might need to recover the trigger also if users messed up the macro. If you need to restore entire Access App, you might need to restore the entire Access database.