Resolve Access Error 3086 - "Could Not Delete From The Specified Tables“..!

Unable to delete your access database tables because each time you tries to do so  “Could not delete from the specified tables” error pop-up to your screen?  Well if you are getting the same issue then this blog is specifically for you. As it contain complete information regarding this specific “Could not delete from the specified tables” MS Access error.  So, that you can easily get rid of this error on your own.

What This Access “Could Not Delete From Specified Tables (Error 3086)” Is?

In Access Database there are several ways to delete records but when you try to delete the multiple records from a table in just one operation i.e by using the Delete Query. Then at that time the following error message appears to your screen.

 “Could Not Delete From Specified Tables”

Error code: Access Runtime Error 3086

Occurrence of this error makes you completely unable to delete data from the tables.

What Are The Causes Of Access Runtime Error 3086?

Check out the following possible causes of this specific “Could Not Delete from Specified Tables” Access Error code.

• May be the permission to modify the table is off. So, change the permission settings and check your system administrator or table’s creator.

• Chances are also that database was opened for read only access. Have a look over the reason which makes the Access Database read-only.

• When the Database file is defined as read-only in the database server OS or by your network.

• In Microsoft VB, you use the data control and set the ReadOnly property to True.

• You must have used the OpenDatabase method and opened database for read-only access.

• In network environment, you don’t have the writing privilege for database file.

• To delete the data, just close down your database and resolve these mentioned read-only conditions. After then open the file for read/write access.

Also Read:

6 Microsoft JET Database Engine Error ‘80004005’ Along With Their Fixes…!

3 Easy Fixes To Resolve MS Access 3052 :“File Sharing Lock Count Exceeded” Error

Manual Fix To Resolve Access “Could Not Delete From Specified Tables (Error 3086)”?

Access database throws this kind of error if you make a delete query with the help of multiple tables and the query's Unique Records property is set to No. so when http://www.accessrepairnrecovery.com/blog/fix-access-file-sharing-lock-count-exceeded-erroryou execute such query the error appears in your Windows screen.

How To Resolve This Issue:

Step 1: firstly you need to open the delete query in Design view.

Step2: If the query Property Sheet is not open, press F4 to open it.

Step 3: Tap on to the Query Designer to show the Query Properties.

Step 4: In the query property sheet you have to find the Unique Records property, and set it to Yes.

Wrap up:

The above solution will surely fix your MS Access Runtime Error 3086. So try it and if in case you are unable to do so then try the other ways to delete records from MS Access.