How do I convert Access 97 queries to Access 2000?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are attempting to convert dozens of Access 97 queries to Access 2000. Can
these be copied directly from one DB to the other?
 
Easiest way would be to Open Access 2000 and then Find the Access 97 database
and open it. Choose to Convert the 97 Database to Access 2000 (It makes a
copy). Close the converted 97 database. Open the 2000 database and select File:
Import. Find the converted 97 db and import the queries. Throw out the
converted 97 database copy when you are finished.

Another method is to open the Access97 database, open the query, switch to the
SQL view, copy the text.
Open the 2000 Database, open a new query, switch to the sql view, paste the text.

I don't know that you can import directly from Access97 into Access2000, but it
might be possible. Try it on COPIES of the databases.
 
I don't know that you can import directly from Access97 into Access2000, but it
might be possible. Try it on COPIES of the databases.
Click to expand...

Works fine in my experience. A200x is somewhat more stringent about
query syntax than 97, so some queries that work in 97 might not in
2000 (in particular, some queries were updateable in 97 but not in
2000/2002).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top