PC Review

Thread Tools Rate Thread

The amazing disappearing VBA code

Posts: n/a
      9th May 2009
I have an MDB that was developed in Access 2003 and now running in Access
2007. It has not been converted to an ACCDB file format yet. The file is
around 30MB with over 40,000 records that are used daily by approximately
200 users across a network. It is not split into a back-end or front-end.
It is on a share network drive that everyone accesses. I cannot, for
several reasons, split it and put a front-end on all the users desktop
across the business.

The problem I am having since upgrading to Office 2007 is that for no
apparent reason, all the visual basic code vanishes. All the forms,
reports, queries and tables seem to be fine, but the code is missing. We
are running Office 2007 SP1 on all the computers. The database starts fine,
the main menu appears, but nothing can be done afterwards.

I first thought that nightly backups were corrupting it, but the start time
of those were moved to a later time just to see if it made a difference. I
put in a time-out procedure that if there is no activity at the user level
after 30 minutes, the database closes for that user. I was thinking that
maybe someone was rebooting the computer while a database was open.

Another thought was that there were network issues across the share drives,
but the network groups says that there is no indication of any problems.

I did not have this issue on Office 2003 and never once had to do a restore.
Now, on Office 2007, I am restoring the entire database and copying tables
at least once a week. We are planing on converting the database to the new
Access 2007 on May 11th to see if that helps.

Any ideas or suggestions would be very helpful. I am at a complete loss on
this one. Thanks.

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
The amazing disappearing VBA code Chuck Microsoft Access VBA Modules 63 24th Nov 2010 03:54 PM
Amazing disappearing taskbar =?Utf-8?B?SmFjayBXaWxzb24=?= Windows XP Accessibility 3 23rd Jun 2005 06:49 PM
Amazing Disappearing E-mail =?Utf-8?B?TGF1cmVuLUlQ?= Microsoft Outlook Third-Party Utilities 1 17th Mar 2005 03:11 PM
CD/DVD drives disappearing, reappearing, disappearing again dgoldsmith@comcast.net Windows XP Hardware 0 1st Dec 2003 07:45 AM
I fixed my amazing disappearing printers jeffNOSPAMgodfrey@hotmail.com Windows XP Print / Fax 0 30th Oct 2003 04:05 PM




All times are GMT +1. The time now is 05:00 AM.