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! http://gsbook.org/could-not/microsoft-access-2007-could-not-delete-specified-tables.php 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.
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. http://gsbook.org/could-not/microsoft-office-access-could-not-delete-from-specified-tables.php 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.