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

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

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

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?

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