Deleting SQL table records using MS Access

[DBAchick]

I linked an SQL table to my access database using an ODBC Connection.  I am trying to delete records from the SQL table using criteria from one of my Access Tables.  When I run my delete query in Access, I receive an error that that Access cannot delete from the specified table.  The MS Access site advised me to check here.  Any ideas out there?

 

[MikeLacey]

I've seen something like this before - you have to have a unique key on the access table before it's updatable (I think)<br><br>If you don't get any joy here there is also an MS Access forum on tek-tips.<br> <p>Mike<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>Please don't send me email questions without posting them as well. Post the question and send me a note saying "Have a look at so-and-so would you?" - that's fine.

 

[Kincaco]

You have to have delete permissions on the table that you are trying to delete records from.&nbsp;&nbsp;Can you delete the records using SQL Plus?&nbsp;&nbsp;If not, it is probably a permissions problem.&nbsp;&nbsp;Otherwise, check the query properties in Access.&nbsp;&nbsp;Make sure it is updatable.<br><br>Hope this helps.