Hi everybody.

I have an Access2000 DB and i'm using ADO to access it through ODBC. I wish to drop and recreate an existing query or even better, alter its SQL statement if possible. Can anyone provide some examples of how to do this?

Please have in mind that the database at some point may be converted to SQLServer so since i'm using ODBC, i wish to do it using generic code.

TIA.