#Deleted in every field????

[cterjesen]

I am linking to another system's tables through an ODBC connection. I've linked to a number of the tables without a problem. However, in one particular table, when I open it up after linking to it, every record and every field has #Deleted in it.

I've called our IT department and they ran a quick SQL select all statement and got everything from the table just fine. He could not figure out the problem. I thought it might have to do with access rights to this particular table, but he gave me the same login and password as he was using.

Any ideas why Access would put #Deleted in here?

THANKS!