Querys not updated - Access 97 to 2003

[alfredoag via AccessMonster.com]

Recently we updated the databases from Access 97 to 2003.

The querys were not updated and the ones that are needed to perform mail
merge are not retreiving the data.

The tables and the data is there, but is not being read.

Is there a methos to update the querys ?

The OS is XP for the clients and W 2000 for the server.

Thanks in advance

Alfredo

 

[John W. Vinson]

Recently we updated the databases from Access 97 to 2003.

The querys were not updated and the ones that are needed to perform mail
merge are not retreiving the data.

The tables and the data is there, but is not being read.

Is there a methos to update the querys ?

The OS is XP for the clients and W 2000 for the server.

Thanks in advance

Alfredo

You should be able to use File... Get External Data... Import to import the
queries (if you still have the 97 database); or at worst you can open the A97
database, open each query in SQL view, and copy and paste the SQL into the SQL
window of the new query.

2003 can be stricter about syntax than 97; you may need to correct some errors
if you copy the query and get an error message when you try to run it.