Application Code disappeared

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roxana - 23 Jan 2008 01:30 GMT

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?

Reply to this Message

Tom van Stiphout - 23 Jan 2008 04:43 GMT

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.

>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
[quoted text clipped - 5 lines]
>data, the forms and reports were still there, but no code !
>Any idea why this had happened?

Reply to this Message

Roxana - 23 Jan 2008 15:36 GMT

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.

> 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
[quoted text clipped - 11 lines]
> >data, the forms and reports were still there, but no code !
> >Any idea why this had happened?

Reply to this Message

Tom van Stiphout - 24 Jan 2008 02:23 GMT

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.

>Hi Tom,
>No, the file extension is MDB.
[quoted text clipped - 20 lines]
>> >data, the forms and reports were still there, but no code !
>> >Any idea why this had happened?

Reply to this Message

Linq Adams - 24 Jan 2008 04:39 GMT

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.

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message