access connection thru odbc to sql server

[ofersd]

i'm using msaccess aplication with linked table to sql server.
when i'importing a table from sql to msaccess all sseem good but
when i'm using linked table
i'm getting on all field the value #Deleted
Has some one have an idee ???????????
ofer

 

[FoFa]

Sounds like it could be a primary key issue. Check that first.

 

[ofersd]

Sounds like it could be a primary key issue. Check that first.

Sorry ir is not a primery key
i all ready check it.
how ever if i making the linked table in excell it's work perfectly
ofer

 

[FoFa]

Well access is basically saying, I think I should have this record, based on the primary key value I have, but it is gone, so it must be deleted.
Have you tried relinking the table?

 

[ofersd]

Well access is basically saying, I think I should have this record, based on the primary key value I have, but it is gone, so it must be deleted.
Have you tried relinking the table?

yes i allready did it couple of times