Can't Delete from Linked Table

[briangriffin]

Access 2007 - I have a user who has a simple database with a linked table to a SQL Server 2005 db. There is no linking on the table.

He needs to purge and repopulate the table, but his delete command yields the error 3086 - Could not delete from specified tables.

When he opens the table in Access and right clicks, the delete command is disabled. However, when accessing the same table from SQL Server, he can delete so I don't think it's a SQL Server permissions issue. And since he created the db, I don't see how Access permissions would be getting in the way.

Thanks in advance for your help.

 

[genomon]

Make sure the table has a primary key defined.

Ni neart go cur le cheile.