The amazing disappearing VBA code

Discussion in 'Microsoft Access VBA Modules' started by Chuck, May 9, 2009.

  1. Chuck

    Chuck Guest

    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.
    Chuck, May 9, 2009
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mike Thomas

    VBA Modules Disappearing

    Mike Thomas, Sep 12, 2003, in forum: Microsoft Access VBA Modules
    Mike Thomas
    Sep 12, 2003
  2. A. Jennings


    A. Jennings, Dec 2, 2003, in forum: Microsoft Access VBA Modules
    A. Jennings
    Dec 2, 2003
  3. Katrina
    Jan 23, 2004
  4. Katrina

    Exporting to Excel through VBA (posted to exporting and VBA group)

    Katrina, Feb 4, 2004, in forum: Microsoft Access VBA Modules
    Feb 4, 2004
  5. Chuck

    The amazing disappearing VBA code

    Chuck, May 9, 2009, in forum: Microsoft Access VBA Modules
    Nov 24, 2010