Code Disappears

  • Thread starter Thread starter roccogrand
  • Start date Start date
R

roccogrand

Is there a reason why the code behind a form would disappear in Access 2007?

David
 
Check that you have closed any extra windows in the code window and then
open the form one again.
 
Jeff,

It went away. It wasn't there. It was vaporized. A virtual dog ate it.

I had to copy the code from a backup. The macros that Access created were
left intact or otherwise the entire app would have been gone.

David
 
Thanks Pete,

I wasn't on site at the time. But I am pretty sure that no other code
windows were open.

David
 
I have had this happen in older versions (very rarely) and every time it was
database coruption. I would copy everything to new database before going
on. Also this only happened when someone was doing the updates to the
datafile over a network, hope you are working on a file on your local PC.
 
This has happend several time when my company upgraded. Our IT people had to
come in and reinstall because of a corrupt file. I can't remember which one
it was, but it took a while for people to believe us that it was an Access
2007 problem, not something we were doing.
 
Thanks Elaine,

I am glad to read that others have had the same problem.

I would appreciate knowing which program(s) had to be reinstalled.

David
 
I develop custom Access databases for several clients. Four of my clients are now using Access 2007. Within the last few weeks, three of them have had the same problem. Suddenly, their database stops working. The reason -- all of the code was gone. All code-behind-forms was gone, and the the code modules were also gone (they showed up in the list of modules, but when you tried to open them, Access said they didn't exist).

Does anyone have a clue as to what's causing this?
 
I too develop databases for several clients. I have had 5 databases at one
site corrupt. 2 of these databases are corrupting every week now for the
past 2 months. This site upgraded to Access 2007 about 12 months ago. The 2
databases that are corrupting every week are front end databases, I now have
master copies on site for the client to just delete the existing front end
and replace it with the clean workable version, but it just goes and corrupts
again.

I need to have a fix for this please.

I have a friend also developing databases. She has 1 instance of this
problem.

Thanks
 
In resposne:
1. vba code from all forms and modules disappears. Any modules still apeear
to be in the database window (but not in the code window), if you try to open
the module it says it doesn't exist.
2. No error messages
3. I will check this with the client
4. No
 
Back
Top