Create a new (blank) database, using Access 2003.
Set the libraries you want:
Tools | References (in the code window.)
Then import everything from the old database:
File | Get External | Import
If everything worked as it should, Access would set the correct library for
you when you open an MDB. If you open in Access 2002, it uses the Access 10
library, and if you open the same MDB in Access 2003, it uses the 11 library
automatically. Most of the time, that works perfectly.
But it is possible for Access to get confused if you have multiple versions
installed on your computer and open at the time when you create a new MDB.
My guess is that this occurs because of the weak linking between the Access
and VBA windows, i.e. Access gets confused since both versions are open at
once. When this occurs, the simplest solution is to dump this confused MDB,
create another one, and import the objects.
