delete query gives read only property

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

Guest

When I use the query wizzard to write a delete query, deleting records in other tables referenced by a primary table, I get error #3086, saying that my database is a read only file. I check properties and find it is not. I can delete individual records in the database, but cannot delete them in the datasheet veiw of the query. What am I doing wrong?
 
When I use the query wizzard to write a delete query, deleting records in other tables referenced by a primary table, I get error #3086, saying that my database is a read only file. I check properties and find it is not. I can delete individual records in the database, but cannot delete them in the datasheet veiw of the query. What am I doing wrong?
Click to expand...

It's probably the Query that is not updateable - some are and some
aren't. See "Updateable" in the online help, or open the query in SQL
view and post it here.
 
Back
Top