Append query error

[lonely]

Hi there,



I am trying to create a append query to add data from previous year to current year, the fields of all three tables are the same, and I can wrong query on those tables separately. The error says: cannot open database ". It may not be a database that your application recognizes, or the file may be corrupt.



Anyone has similar error before? Figured out?

Thanks,

Luna

[NoellaG]

Hi Luna,
are the tables with the previous year in the same database as the tables with data from the current year?

kr - NG

[ranman256]

if you are IN access db then the DB is not corrupt. It could be a false error of the query.

are you appending pure values and not fields from another table?
is the target table internal or an external linked table>?
is this a query built by you , or is it SQL?

[lonely]

Yes, NoellaG,

They are in the same table.

When I try to create a new table, similar error happens, but it is OK if I import data from Excel to create a new table.

[lonely]

Hi Ranman,

Thank you for looking into it.

I am appending pure values, not creating any fields.
The target table is internal, and do not linked with externally.
I used the query design, and did not write the SQL. I successfully run append query before, no ideal why the thing happens.

[ranman256]

did u try repair/compacting db?

[NoellaG]

Hi Luna,

you could open the query in SQL modus and look if there isn't a point in front of a table name. If you have something like

select .MyTable.MyField from MyTable

access would assume the table name is preceeded by the database name. And because there is no name you could get the error Have not found database '' (empty string).


kind regards
NG

[lonely]

Hi NG,

I have tried the SQL modus, there is no . in front of the table name.

I fixed it by repairing the DB.

Thank you.

Luna