Converting 97 database to 2000

[Guest]

I am trying to convert a 97 database to 2000. But I get the following error:
"Invalid database object reference" and the database won't convert. Can
anyone give me a hand with this? Thanks!!!

 

[Allen Browne]

Suggestions

1. Use Access 97 to decompile the database, by entering something like this
at the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

2. Then open the database in A97, and compact it.

3. Open a code window, and see what references it uses. Remove any you don't
need. For info about references, see:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If it still fails to convert, post back for more suggestions on how to
recover from corruption.