10-14-2012, 08:48 PM #2 mahenkj2 Newly Registered User Join Date: Apr 2012 Location: Earth Posts: Union All SQL Action Queries Append Query versus Make Table Query Update Query Examples and Errors and VBA This Recordset is not updateable Delete Query Examples, Errors and VBA Hide Action Besides those there are no constraints. –user1466887 Jul 9 '12 at 20:32 Does any of your primary keys have relationships? –DrinkJavaCodeJava Jul 9 '12 at 20:33 No, Ms Access Delete Query With Join

If it's in MySql it's likely that you don't have the proper permissions to edit table data. The Archive query works fine but when I execute the delete query I get a message: "Could not delete from specified tables" The archive and delete vba code is as follows: asked 4 years ago viewed 11106 times active 3 months ago Get the weekly newsletter! Open the delete query in Design view.

Then re-link the table in Access and make sure to tell Access which field (or combination of fields) to use as a primary key. Runtime Error 3086 Could Not Delete From Specified Tables More About Us... Combines two tables that have a one-to-one relationship.

I used a query to distill the somewhat complex selection criteria down to a set of primary keys for the table targeted for record deletion.

Unfortunately, I have tried that, as Access puts this > > in when you set the UniqueRecords property. > > > > If it helps, my SQL reads: > > > If Access isn't aware of a linked table's primary key, the link will be read-only. How to block Hot Network Questions in the sidebar of Stack Exchange network? Could Not Delete From Specified Tables Access 2010 Linked Table Drop the column?! –onedaywhen Sep 1 '09 at 13:36 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted From within Access can you open your

I am suspecting some kind of a lock on the table because the same delete query as I used above worked for a different user from their machine –ElenaDBA Nov 3 However the problem still persists. > > Please can anyone help? > > Thanks, > Jim F. > > Michel Walsh, Nov 21, 2003 #2 Advertisements James Franklin Guest Hi Update one of the fields with an out of scope value then delete based on that flag. Example of a Delete Query that Fails to Run For instance, you may want to delete people from TableA who are in TableB by linking their name fields (both tables have

They are extremely powerful, fast, and eliminate manually deleting records and writing unnecessary code. If there are related records linked through cascading deletes, you'll want to archive those records before deleting the main records. When a table passes a million records then it is starting to get substantial.