I don't understand this error message

sportsguy

Finance wiz, Access hack
Local time
Today, 16:01
Joined
Dec 28, 2004
Messages
363
I can open the backend database in access 2007, i can open the linked table in the front end database. The backend database has a single table in it and the table is empty. I have repaired and compacted the backend db several times. I can't run an append query to the linked table, as I get the following error message:

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

Huh? is there something i am missing?

sportsguy
 
Not sure how you are running the query.
Because the table is linked, you don't need to do anything special to append data into a linked table. The query is the same as if you were appending to a local table in the front end.
If you already know the above, post back with the sql of the query.
If you are pretty sure there is nothing wrong with the query, then try creating a new database and importing all objects into it.
 

Users who are viewing this thread

Back
Top Bottom