Disassociated Event Procedures?

[landar]

I have an Access 2000 database I created with Event Procedures attached to the On Click Event line in Command buttons' Properties menu. This, so far, is not unusual. However, the Event Procedures on my buttons suddenly started associating themselves strangely.

Without making any changes to the database whatsoever, the Event Procedures suddenly began associating themselves to things that were not of the appropriate name, or just disappearing altogether. If I attempted to click on the ... box to create a new procedure, the VB Editor would create a new blank sub above the already existing sub. If I then copied the code from the old sub to the new, I would then lose the Event Procedure in the Properties of the Command Button. If I attempted to delete the old sub, Access would crash with a Windows NT error (no details concerning the error were provided) and then shut down.

Has anyone experienced this before, or have any suggestions as to what I can do to save my database?

I have already tried to Compact and Repair the database.

Thank you very much for any help you can provide me with. I do not want to have to re-create this database.

~Seth Neustein

 

[Jack Cowley]

Try importing everything into a new, blank database....

hth,
Jack

 

[landar]

I do not know why such an obvious thing did not occur to me. Thank you so much for your suggestion, as that worked.

Although what is weird is that the original database is in an Admin locked format that I cannot unlock, and even though shut down (and after a reboot) the .ldb file still exists. So I had to create a copy of the database (copy and paste) and was able to use the copy (which was still screwed up) to do a fresh import.

Thanks again for the help.

~Seth Neustein

 

[Jack Cowley]

If the .ldb file remained after closing the db then delete the .ldb file...

Jack

 

[landar]

I cannot delete it. Even after rebooting my PC (since the database resides on my hard drive) the .ldb file still remains and when I click "Yes" to delete it, I receive a sharing violation error message stating the file is still in use.

~Seth

 

[Jack Cowley]

Do you get that when trying to delete it from Windows Explorer and the db is closed? If you are then you have just exceeded my knowledge of the .ldb file...

Jack

 

[landar]

Unfortunately, yes. However, thankfully it is not a large database and does not appear to actually be taking up any virtual memory, so perhaps it will one day delete itself.

Thanks again for the help.

~Seth