Querys not updated - Access 97 to 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alfredoag - 12 Mar 2008 05:27 GMT

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

Reply to this Message

John W. Vinson - 12 Mar 2008 06:24 GMT

>Recently we updated the databases from Access 97 to 2003.
>
[quoted text clipped - 10 lines]
>
>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.

Signature

John W. Vinson [MVP]

Reply to this Message