Convert Access XP database to Access 2000 problem

[Guest]

I have an Access XP database which was originally converted from an Access
2000 format.

Since then I have made updates and changes to it, however the environment
that I need to implement it in has only Access 2000. When I use the database
conversion tool to 'roll it back' to the 2000 format, none of the tables,
forms, queries, reports etc show up !?!?!

Is there anyway I can fix this up?!?!

HELP!

Cheers, Isaak

 

[Allen Browne]

It should convert back through:
Tools | Database Utilities | Convert ...

If that fails, the database must be partially corrupt. Try this sequence:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access 2002. Make a backup copy of the file. 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"

4. Open Access, and compact again.

5. Try the conversion again.

 

[Guest]

Thanks, Allen

I managed to get around it by converting the database to Access 97 then back
up to 2000... I knew there was a chance of loosing some functionality but so
far it all look good...

Thanks for your help though Allen!

Regards, Isaak

from Perth, Western Australia too!