Access 07 and SQL Server ‘linking’ problem.

Hi,

I’m having problems linking to my SQL database with Access 07.

I can see all my relevant tables structurally, but I cannot edit any content
and all fields display ‘Deleted’.

As weird as it sounds, if I ‘Refresh’ some of table contents will appear
and then disappear back to Deleted. There were no such problems with
Access 03.

Any thoughts will very much appreciated. Thanks