Access 2000 database wont open in Access 2003

  • Thread starter Thread starter Alan Klietz
  • Start date Start date
A

Alan Klietz

I have an Access 2000 MDB database that opens fine on Access 2000 and Access
2002. However when I try to open the MDB file on Access 2003 I get a
compile error on every VB function. It acts as if the reference to the
VBE6.DLL is missing from the project.

So I go take a look at the library references list. In the code window when
I click on "Tools" on the menubar, the "References" menu item is grayed out!
What the heck is going on here?

It acts almost as if it thinks it is a compiled MDE file. But I can see the
VB source code and edit it just fine. Repair does not help, and it refuses
to convert to 2003 format. On the hunch that maybe the file is corrupt I
tried exporting and re-importing every object (on Access 2000) to a new
..MDB, but the problem followed the new file.

I tested this on three different new installs of Office 2003 and it acts the
same on each one. I'm at my wits end. This MDB file is critical to us and
is holding up a major upgrade to Office 2003.

Thanks in advance,
Alan Klietz
Algin Technology (alank AT algintech D-O-T com)
 
Create a new mdb in Access 2003.

Are the references fine in the new file?
- No: remove and reinstall A2003.
- Yes: try importing everything from the A2000 mdb.
 
In
Allen Browne said:
Create a new mdb in Access 2003.

Are the references fine in the new file?
- No: remove and reinstall A2003.
- Yes: try importing everything from the A2000 mdb.
Click to expand...

It turned out that the problem was a missing reference to the OLE Automation
library (STDOLE2.TLB). Access 2000/2002 doesn't mind the missing reference
but Access 2003 throws a conniption fit without it. It seems to be working
now.

Thanks for the fast feedback.

Regards,
-Alan
 
Back
Top