Access 2010 FAQ
Why can’t I restore my record from the SharePoint recycle bin?
If you have a data macro attached to the BeforeChange event of a web table, you cannot restore records back into that table from the SharePoint Recycle Bin. If you want to recover the deleted records, you’ll need to temporarily remove any data macro logic attached to the BeforeChange event for the web table from within Access client, save the changes to the server, restore the deleted records, and then reattach any data macro logic to the BeforeChange event. To facilitate this process, you could copy the data macro logic to Notepad and then paste the XML back into the BeforeChange event after restoring the deleted records.
See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out
Back to FAQ main page