Problem with Access 2002 after changing an enabled database with Access 97

[Fleming]

I (or better Microsoft Access) encountered a problem when
I open an Access 97 database that was already enabled for
Access 2002 but has been changed afterwards with Access 97.

I want to know, if I got it wrong, that it should be
possible to change a database (with Access 97) that is
already enabled (for Access 2002)?

I can always recreate the problem like this:

1. Create an empty mdb with Access 97
2. Open it with Access 2002 to have it enabled (i.e. no
conversion)
3. Open it with Access 97 again and add a form (no
functionality, just an empty form)
4. When I now open this file with Access 2002 again, I
first see the Open/Convert dialog as usual. I select to
Open (no conversion) and after I clicked OK, the same
dialog appears again and after a short while, I get a
Problem Report Dialog with the option to have the database
repaired.

After the database is repaired, I have not found a problem
yet.

 

[Bruce M. Thompson]

I (or better Microsoft Access) encountered a problem when

I open an Access 97 database that was already enabled for
Access 2002 but has been changed afterwards with Access 97.

I would recommend one of two approaches here: 1) keep a copy of the original
database for modifying and then copy it to another location for use with your
Access 2002 sessions or 2) don't open it with Access 2002 - if Access 97 is
available on the workstation opening the database file then use that version.

Later versions of Access, to identify that an MDB was previously opened without
conversion to the current version, likely makes a small modification to the file
(a "flag", so to speak), so you probably should avoid additional cross-version
modifications after that has been done.