Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Deleting from a linked table

Author  Topic  MuadDBA 628 Posts Posted - 2001-11-01 : 14:51:00 My co-worker has used an ODBC link to a SQL7.0 table from MSaccess, and is trying to run a delete query as part of a macro. He keeps getting the error that he must use an updateable query.... We've checked permissions, recreated the ODBC data source, and tried using the SQL view to write the query....it doesn't seem to work no matter what....I can't even highlight records and then delete them...can anyone help me out here? I am using a SQL username and password, the SA acount for cripe's sake...why can't he delete from this table? (and yes, I can delete from it in QA)