Microsoft access error 3086 delete query

Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Step 1: Open the delete query in Design view. Step 2: If the query property sheet is not open, press F4 to open it. Step 3: Click on the query designer to display the query properties. Step 4: In the query property sheet you have to find the Unique Records property, and set it to Yes.

So, maybe the issue is with the delete query so try some other ways to delete the records from the Access Database. Or else in the navigation form, make a selection for the form that you want to use, and on the Home tab, in the Views group, tap to the view option. After then tap to the Layout View. By default, make double quotation marks surrounding the items in the value list. As per your requirement, remove the items from the list. Hey guys, I'm trying to build a delete query that will remove records in my main table that match any stored in my history table.

The problem is that I keep getting the following no matter how I try to build the thing: Could not delete from specified tables. Error You tried to delete data from one or more tables, but the deletion could not be completed.

Possible causes: You do not have permission to modify the table. To change your permissions assignments, see your system administrator or the table's creator. The database was opened for read-only access. The database is read-only for one of these reasons: You used the OpenDatabase method and opened the database for read-only access.

The database file is defined as read-only in the database server operating system or by your network. In a network environment, you do not have write privileges for the database file. Local time Today, Joined Jan 12, Messages 32, DreamGenius Annoying Questionner.

Local time Today, Joined Jul 29, Messages I was searching for the solution to this same problem and, though Bob Larson's suggestion was not true in my case, I found that changing my query from two joined tables to embedded select queries, I got around the problem. Welcome to our community! I'm using the following code: DoCmd.

Does anyone have ideas why this would happen? I can insert, update and append to this table. I have full rights on the table. Join our community to see this answer! Unlock 1 Answer and 5 Comments.