We have a basic Access 2007 application which polls data from a table and creates an Excel spreadsheet. There are 4 tables, 1 form in the .accdb.
I tested the code on Tuesday and everything worked fine. Today (Thursday) we had a user go log in and open the .accdb. When he logged in, the buttons on the form did not work. He alerted us and when we went in we found all of the VBA code was gone. If I right-click on the button, and view properties, I can see that "OnClick" there is an evert procedure, but if I open the VBA editor, it opens a blank page and automatically inserts the Function header as if I were writing for the first time.
I have not been able to replicate this issue, I've tried varying levels of security, but the code remains intact in every case.
Is this a common issue with Access 2007? We developed this app from scratch within 07, so it is not a migration issue from an earlier version.
My concern is that i do not want it to happen again, we had a backup but still there was a significant amount of time the user could not get in and do his work.
Thanks for any info.