I have linked a table to MS Access 2003 from SQL 2000 server and figured there are some records with all the field value #delete. When I use Query Analyzer, I am sure those records contain values instead of #delete. Or even when I import the table instead of link, I can get correct values. Can anyone please advise a solution because I need to link a table? Thanks.