Is there a way to run SELECT queries on an Access 2003 database from Access 2.0?

Question

I have an Access 2.0 application that I need to interface with an Access 2003 MDB. The only thing that needs to be run on the Access 2003 MDB are SELECT queries, nothing else. Is there a way that I can do this? If I have to set up an ODBC connection, that's fine.

Importing the queries is not an acceptable solution. The queries MUST be run from the Access 2.0 side. And the queries must also run programmatically, not via the frontend.

Answer 1

see if you can IMPORT the queries into the 2003 DB. Run them from the front end.

Answer 2

You can convert a copy of the Access 2003 DB into an earlier version using the TOOLS:Database Utilities:Convert Database function.

Answer 3

Assuming that any motorized vehicle no longer recorded as ever having one needs one at 4500 miles: go with v.ProductID, (COALESCE(nextDue, 4500) AS "Mileage next Due" FROM motorized vehicle v LEFT OUTER connect (go with ProductID, MAX(endingMileage) + 4500 AS nextDue FROM service the position purpose = "Oil substitute" crew through ProductID) s ON v.ProductID = s.ProductID