I have a database that was originally set up in Access 97 (because that
was what we had in the office). We had a copy of Access 2000 set up on
one machine for a brief period to get at another database that required
it. Unfortunately someone used that machine and "upgraded" the Access 97
database to Access 2000.
Now I'm trying to get it back to Access 97 but the "convert to prior
version" function keeps telling me that it can't convert the database
because it's a replica. It isn't. It is the design master. I do have
replicas of it because we used replicas to do work offsite.
I was able to convert the Access 2000 database down to Access 97, so I
know the function does work. However I can't get the function to work
with the database that was up-converted from Access 97.
I also can't export the tables in the database and recreate an Access 97
database from them because two tables are linked on an auto-increment
field. I don't see anyway of preserving the auto-increment during the
export / import steps.
Anyone have any ideas? TIA!