| re: convert Access 2000 db back to Access 97
Have you tried importing all the tables, forms etc into a new database
and then saving it as a 97 version?
Patrick
On Sun, 19 Oct 2003 20:06:36 GMT, Gary Dale <garydale@rogers.com>
wrote:
[color=blue]
>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!
>
>
>
>
>
>
>[/color]
| 
