Code Disappears

[roccogrand]

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

David

 

[Pete D.]

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

 

[Jeff Boyce]

Define "disappear"... from where?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[roccogrand]

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

 

[roccogrand]

Thanks Pete,

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

David

 

[roccogrand]

I know of one case in the Southeast. I am in the Rockies.

David

 

[Jeff Boyce]

Glad you had a backup!

I haven't heard of this happening before. Have you tried doing an on-line
search to see if other folks have run into this?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Pete D.]

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.

 

[Elaine]

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.

 

[roccogrand]

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

 

[Phil Joslin]

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?

 

[Sally Green]

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

 

[AccessVandal via AccessMonster.com]

1. What kind of corruption?
2. What is the error number and description?
3. Is Access 2007 SP1 applied?
4. Is your database file increasing in size?

You can try the hotfix here
http://support.microsoft.com/kb/960307
but I can't guarantee that it will work. But it does deal with missing codes.

 

[Sally Green]

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

 

[AccessVandal via AccessMonster.com]

Hi Sally,

Well, the hotfix might help but not sure about the corrupted DB.

Here a site from Allen Browne corruption

http://allenbrowne.com/Access2007.html

http://allenbrowne.com/bug-03.html

Autoname correct problems.

http://allenbrowne.com/ser-69.html

Prevent users form modifying your db.

http://allenbrowne.com/bug-DeleteOnCompact.html

Also on compacting if you use compact on close. You might also want to try
using Decompiling or you are you distributing the db as a MDE or ACCDE?