ODBC Connection showing row values as #Deleted

  • Thread starter Thread starter Sarah
  • Start date Start date
S

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
 
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)
 
It was the BigInt data type. Thank you!

Sylvain Lafontaine said:
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)
Click to expand...
 
Back
Top