Search code examples
sqlms-accesssqlconnectionms-access-97

Change DB that Access query points to

I'm trying to make a query in Access 97 point to a different database. I cannot find out how to change the db. I've tried adding another odbc connection but it doesn't give me the option to choose it when running the query.

I've tried to create another query but it still has the old db tables and i cannot choose the new db tables.

Any suggestions would be much appreciated.

thanks, Nighmares

Solution

  • Try viewing the SQL source of your query. Is the old database name there? Can you just replace it and save your change? Another option would be to point your existing ODBC connection to the new database.