Error loading form in Access 2003

[Guest]

I have a problem with a database. I have a user that has been upgraded to
Access 2003 from Access 2002 (XP).

When the database is opened I get a message:
"An error occurred while loading 'Form_All Active Projects'. Do you want to
continue loading the project?

If I click YES, I get another message stating:
"Invalid procedure call or argument"

If I open the database in Access 2002 (XP) the database operates with no
problems. Am I missing something?

I compacted and repaired the database in Access 2002 and ran the conversion
tool to make sure it was in a Access 2002 and Access 2003 format. Then opened
the database in Access 2003 and got the same error messages.

The machine with Access 2003 does have Office 2003 SP1 installed, by the
way, I was getting the errors before the Service Pack was applied as well.

Any help would be appreciated, I have exhausted all other ideas.

 

[Allen Browne]

The problem suggests that there is an insipient corruption in the database.
Since A2002 and 2003 use different binaries for the compiled code, a
decompile may help.

On the machine that has A2002 installed, close Access and enter something
like this at the command prompt. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then open in A2002 and compact.
Now try opening in A2003.

Access keeps 2 copies of the code:
- the text version (what you see and edit);
- the compiled version (what actually runs).
If these 2 are out of sync, you get strange problems.
Decompiling dumps the compiled version.
Access then creates it again automatically, and so the problem is gone.

 

[Guest]

I followed those instructions. I still get the same errors.

 

[Allen Browne]

Tony, is there any chance this could be a bad reference?

On the machine that shows the problem, open any code window, and choose
References on the Tools menu. Which references are checked? Are any of them
marked missing?

Ideally you will have only 3 references. The files for each version are
listed at:
http://allenbrowne.com/ser-38.html
Sometimes you need to deselect the references (apart from the 2 required
ones--Access and VBA), restart Access, and then reselect them.

Do you actually have a form named "All Active Projects"? Is this form
supposed to open when you start the database?

There are other possible issues, such as naming clashes.