Delete Query Error Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Delete Query in Microsoft Access 97. I get an error that states
"Operation must use an updatable query". Its has a 1 to 1 relationship and
there is no security setup that would block this. If I preview the query it
runs fine and displays the correct information, but when I actually run the
delete query I get the error. Any Ideas?
 
Hi Josh,

You may want to check the query properties to see if unique records is set
to yes. I believe that this is a common problem with delete queries.

If that's not it, try posting the sql txt of your query (copied from sql
view), maybe there is something else going on.

HTH, Ted Allen
 
Back
Top