Application Code disappeared

[Roxana]

I have this Access application with a few forms with buttons that update
tables, call other forms and creates reports. The application is saved on the
LAN in a secure location with limited access to it. Last time this
application was used was end of Dec 2007. In Jan 2008 we converted to Office
2007. The next day after the conversion we tried to open the database but the
buttons were not working. When I wanted to look at the code (to debug) I
realized there was no code. All the code had disappeared ! The tables, the
data, the forms and reports were still there, but no code !
Any idea why this had happened?

 

[Tom van Stiphout]

On Tue, 22 Jan 2008 17:30:23 -0800, Roxana

What is the exact extension of your file? I bet it's MDE which is a
compiled version of an MDB. There is no code in an MDE. You have to
find the MDB.

-Tom.

 

[Roxana]

Hi Tom,
No, the file extension is MDB.
This application works in conjunction with 2 other databasese which contain
tables which are linked into the application database.
I was able to retrieve the Dec version of the database from the backup and
it looks OK. Code is there and works. Could it be possible that the file was
corrupted during the backup? This is the only explanation I can think of.
Thanks.

 

[Tom van Stiphout]

On Wed, 23 Jan 2008 07:36:00 -0800, Roxana

Same here. I think your MDB was corrupt. Good thing you had a backup.
You're already ahead of some other posters in this NG.
Perhaps you'll burn it on CD and give it to the president of the
company as a company asset she may want to safeguard.

-Tom.

 

[Linq Adams via AccessMonster.com]

I believe when a previous version with VBA code (like that behind buttons) is
migrated to ACC2007, you have to designate the folder holding the db as a
"trusted" site.