#deleted appears when linking sql to access 2007

I have linked a sql db to access 2007. All the records on the table show as #Deleted when they are not. I remember having that problem back in access 2.0, unfortunately I do not remember the solution.

HELP!!!!!!