ODBC Connection showing row values as #Deleted

[Sarah]

I am linking to an Enterprise database from an MSAccess 2007 database. When
I open the table I'm linked to all the row values have the word #Deleted in
them. Yet I can append to the linked table and append data from the linked
table to another table in my Access 2007 database. Any ideas on why I see
the word #Deleted and not the actual values in the table?

Thank you.

Sarah

 

[Sylvain Lafontaine]

Most plausible explanation: there is no primary key on the table or it's
constitued with an incompatible type for Access such as a BIGINT.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[Sarah]

It was the BigInt data type. Thank you!

Most plausible explanation: there is no primary key on the table or it's
constitued with an incompatible type for Access such as a BIGINT.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)