By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 869 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

convert Access 2000 db back to Access 97

P: n/a
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!


Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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 <ga******@rogers.com>
wrote:
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!



Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.