delete query gives read only property

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?
 
J

John Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Can't Run Delete Query to Get Rid of Dupes 4
Delete Duplicates with a Delete Query 3
Delete query error 3086 4
DELETE QRY issue 4
Delete Query wont work 3
Creating a Delete Query from an Unmatched Query 3
Delete Query failure 5

Top