Access connected to SQL - "#Delete" value 1

[123edtech]

Hi,
I'm using Access connected a SQL Server database. In the Access side, some tables are OK but others show "#Delete" value in each cells of the table. More... the table show all the rows!!! I verify the SQL database and all fields are OK.
Try to understand !!!

Is there anybody who can help me to understand ?

Thanks.

Erik

 

[PHV]

Have you checked that the linked tables have a Primary Key, or at least a unique index ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[123edtech]

Thanks PHV,

Yes, each tables have his Primary key.
Do you have a other idea ???

;-)

 

[darkwing75]

I don't think Access likes the ntext or the other large nfields..

 

[123edtech]

I found the problem but I forgot to publish it.

The problem was Access don't like the BitInt values. When I changed my Primary Key From BigInt to Numeric, the problem was solve.