Error using append query

Question

I have a number of linked ODBC database tables that I can open with no problems. I can use a query to open and filter the data as well, but when I try to use an append or make query to place the data into another table, I am getting the following error message.

            Cannot open database. It may not be a database that your application recognizes, or the file may be corrupt.

Any ideas as to why this would happen?

Answer 1

You can export a query (I just tested) except apparently not a pass-through. If you are using ODBC Server it is typically more efficient to use pass-through queries if all of your tables are on the same "ODBC Server". You can create an Access query with a source of a pass-through query.

Without knowing your situation, I would still recommend using fewer queries and making them SELECT queries. It looks like you are breaking apart a table, creating separate tables, and the appending them back together.

When I need to use temporary tables, I typically create a temporary ACCDB file to store them. This avoids the bloat associated with make table and append queries.

Answer 2

The pass-through queries use the SQL language from the server, not Access. They are typically quite similar but most ODBC servers have greater functionality.

Let us know if you have more questions.