2002 database corrupt and unuseable after upgrading to Access 2003

From: James Carpenter (JamesCarpenter_at_discussions.microsoft.com)
Date: 03/07/05 

Date: Mon, 7 Mar 2005 14:45:05 -0800

I'm seeking advice on an Access 2002 database with VBA code which will not
open in Access 2003. The database was operating successfully under Access
2002, and was compacted and repaired before the 2003 upgrade was installed.
It is a single-user database still under development; there are several
backup copies, all displaying these symptoms.

The database has an autostart form which displays a few seconds, then closes
and launches the main switchboard. Launching in 2003 generates the Microsoft
Visual Basic message while the form displays: "An error occurred while
loading 'Report_R_Agg_S_I'. Do you want to continue loading the project?"
This refers to an empty class module.

Clicking "no" produces the message "The VBA project in the database is
corrupt."

Clicking "yes" gives the message "Invalid procedure call or argument" and
opens the debugger to a module that isn't running at this point.

Opening the database with the shift key down bypasses the autostart form,
but then opening the VBA code produces the same sequence of errors.

Converting the database isn't possible because it is already in 2002-2003
format. Compact and repair under 2003 generates the same sequence of error
messages and fails.

Has anyone experienced similar problems? If so, how were they resolved?
Sorry so wordy; just trying to describe the situation as completely as I can.
Thanks to anyone who can offer help!

Relevant Pages

  • Re: Multiple Forms saving to 1 table
    ... See Duane Hookum's At Your Survey sample database for an example: ... Tab Control on the form rather than multiple forms. ... argument in the VBA code that opens the form. ...
    (microsoft.public.access.forms)
  • Re: 2002 database corrupt and unuseable after upgrading to Access 2003
    ... it sounds like you have a partially corrupted A2002 database. ... a decompile might fix the problem. ... >> opens the debugger to a module that isn't running at this point. ... >> but then opening the VBA code produces the same sequence of errors. ...
    (microsoft.public.access.conversion)
  • Re: db repair
    ... Server. ... VB Script looks amazingly like VBA, since they're both based upon the same ... See http://www.mvps.org/access/general/gen0041.htm for the VBA code to ... this won't compact the database ...
    (microsoft.public.access.setupconfig)
  • Re: 2002 database corrupt and unuseable after upgrading to Access 2003
    ... That will depend on the kind of corruption, but given that A2003 is barfing ... it sounds like you have a partially corrupted A2002 database. ... >>> opens the debugger to a module that isn't running at this point. ... >>> but then opening the VBA code produces the same sequence of errors. ...
    (microsoft.public.access.conversion)
  • Sending Word bookmarks to Access
    ... I have built an Accessdatabase which was converted to 2003 and an ... Access form to send out assignments. ... The form has VBA code to send the ... Macros on the Word document are also gone. ...
    (microsoft.public.word.vba.general)
Loading