Query results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone knows what does it mean when Access returns as query results the following '#Deleted' value in all fields? I'm running a query on a fairly big linked table from external datawarehouse through an ODBC, and from one table (which have real values in it) I'm receiving all the time this '#Deleted' results. HELP!!!
 
The only time I have seen that happen was when I was
accessing a table and someone else was in the process of
re-loading it.
-----Original Message-----
Does anyone knows what does it mean when Access returns
Click to expand...
as query results the following '#Deleted' value in all
fields? I'm running a query on a fairly big linked table
from external datawarehouse through an ODBC, and from one
table (which have real values in it) I'm receiving all the
time this '#Deleted' results. HELP!!!
 
My guess is that the query is reading a linked table--
perhaps through ODBC--and something in the path between
your database and the linked table has become corrupt.

The solution is to delete the linked table from your
database (this doesn't delete it from its source) and re-
link it.

A word of caution: I tried this recently and now cannot
relink my tables--I'm getting JET ISAM errors, probably as
the result of a recent XP security patch to my machine. I
recommend that before you delete the linked table you link
it again (Access will add a '1' to the end of the table
name) and test it before you delete your original linked
table.

Good luck.
-----Original Message-----
Does anyone knows what does it mean when Access returns
Click to expand...
as query results the following '#Deleted' value in all
fields? I'm running a query on a fairly big linked table
from external datawarehouse through an ODBC, and from one
table (which have real values in it) I'm receiving all the
time this '#Deleted' results. HELP!!!
 
Back
Top