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)


"Sarah" <(E-Mail Removed)> wrote in message
news:CCEEC793-2C41-4864-A3D8-(E-Mail Removed)...
>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

It was the BigInt data type. Thank you!

"Sylvain Lafontaine" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:CCEEC793-2C41-4864-A3D8-(E-Mail Removed)...
> >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
>
>
>