Access 97 and 02 Compatibility Issues

[Guest]

Have a database originally designed in Access 97'. Changes/updates made to
the database design and format in Access 02', then converted back to Access
97'.

Now, cannot open the database in Form View - get a message that states
"Microsoft Access cannot open the form '________'. It contains data that
Microsoft Access doesn't recognise. Re-create the form or, if you maintain
backup copies of this database, retrieve a copy of the form".

Is this an issue between multiple versions of Access? The person who made
the changes to the database in Access 02 is able to open up the database in
both his Access versions - 97' and 02'.

Is my only option to download a newer version of Access?

Thank you!

 

[Guest]

Check the help screens of your Access 97 for the latest update info. You may
need to apply an update or a service pack (if it's still available anywhere).

 

[Guest]

I just came accross this site and thought it might help you.
http://www.mvps.org/access/resources/patches.htm#acc97
It has patches/fixes for Access97

 

[Allen Browne]

If everything else works fine except this form, then it looks like you have
a corruption.

To rebuild it:

1. Decompile a copy of 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. Compact the database:
Tools | Database Utilities | Compact.

3. Create a new (blank) database.
Import everything:
File | Get External | Import.