Hello Everyone,

One of my Access database was not working yesterday, and I found out the reason: because all of my VB code were missing from Fomrs, Reports, Modules..

My questions are:
1. Why did it happen?
2. How can repair the problem (I used the backup DB to replace it)?

Thanks,
Cindy

Sounds like you corrupted the VBA code.

What version of Access including SP level?

Is your database split? if not I would do this ASAP. See: Splitting your Access database into application and data

Converter the front end to an MDE/ACCDE for production use.

I make a backup for every front end master (.mdb/accdb) before I open it to make changes.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

I put the database in the network server.

Server: Window server 2003, SP2;
work station: Window XP SP3;
Access database: 2007

our database is not splited, I will go to that link to study it.

Thanks,
Cindy

Cindy,

Thanks for the information. It would really help to know what version of Access you have installed (running).

See: Where is the About dialog for Office 2007 applications

I would make sure that you have Office 2007 SP2 installed.


Having multiple computers opening the same (shared) database from a file share can definitely cause issues like database corruption.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Yes, we have Office 2007 SP2 installed.

Thanks,
Cindy

I would make sure that every computer has the SP2 update installed. It is possible if just one computer does not have SP2 installed and it opens the database you could have problems.


Every database I have developed, work on, or will even use is always split. I also only use a complied MDE or ACCDE (2007/2010) front end for any production work. This also prevents the VBA code from getting corrupted.


Back with Access 2000 there was an issue with the VBA editor. When you paste VBA code and did not manually run a compile it could corrupt the VBA code for the entire databases when you exited. For over 10 years I have developed a really good habit of always manually compiling the VBA code whenever I am in the VBA editor. Since I started doing this years ago I have not had any more issues with the VBA code getting corrupted in a mdb or accdb.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thank you so much, HiTechCoach.
I will ask the end users to check 2007 SP2 installed, and also consider your suggestion.

You are great!

Cindy