Ms Access Error 3128
Custom Search UtterAccess Forums>Microsoft® Access>Access Queries Error: 3128 - ?, Access 2007 Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options kms_bcbsView Member Profile Feb 22 2013, 10:20 AM Post#1Posts: 13Joined: 31-October 12Good morning! I'm havin
soon) Ruby (coming soon) Getting Started Code Samples Resources Patterns and Practices App Registration Tool Events Podcasts Training API Sandbox Videos Documentation Office Add-ins Office Add-in Availability Office Add-ins Changelog Microsoft Graph API Office 365 Connectors Office 365 REST APIs SharePoint Add-ins Office UI Fabric Submit to the Office Store All Documentation https://www.yammer.com/ http://feeds.feedburner.com/office/fmNx Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error 3128 when trying to delete records Microsoft Office for Developers > Access for Developers Question 0 Sign in to vote I am http://www.utteraccess.com/forum/Error-3128-t2000491.html attempting to debug an application done with MS Access 2010. There is a failure with error 3128 - specify the table containing the records you want to delete. This happens on the first step of a macro that opens a query with the following statement: DELETE [Receivelog Details].*, Receivelog.[ROR No] FROM Receivelog INNER JOIN [Receivelog Details] ON Receivelog.[ROR No] = [Receivelog Details].[ROR No] WHERE (((Receivelog.[ROR No])=[forms]![Do https://social.msdn.microsoft.com/Forums/office/en-US/7bbd85fc-c1eb-4ca2-ba7e-c6b4a64dcc08/error-3128-when-trying-to-delete-records?forum=accessdev Manifests].[selectROR])); I am able to execute a datasheet view with query and get the correct results, so I don't think there is a problem with the WHERE section. I am confused as to why it feels I have not specified the table. Any assistance would be greatly appreciated!! W. Brown wallybrown61@hotmail.com Wednesday, January 20, 2016 6:33 PM Reply | Quote Answers 0 Sign in to vote As you are restricting the query by a parameter on the key, why do you need to reference the ReceiveLog table at all? DELETE * FROM [Receivelog Details] WHERE [ROR No] = [Forms]![Do Manifests].[selectROR]; The only reason I can think of is that there are rows in Receivelog Details without a match in Receivelog, which you want to retain. This would be unusual as it is normally the case that it is rows without a match which are to be deleted, not the reverse. BTW I'd strongly advise against including your email address in a post to a public forum like this; it's an open invitation to spammers to harvest it. If you do need to cite the address then mung it, e.g. wallybrown61
here for a quick overview of the site Help Center Detailed answers http://stackoverflow.com/questions/6710011/delete-query-error-messagespecify-the-table-containing-records-u-want-to-delet to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow ms access Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Delete query error message:“specify the table containing records u want to delete” up vote 0 down vote favorite I want to delete all records from ms access error table "T" if the records are also in table D, but I am getting the error message "SPECIFY THE TABLE CONTAINING THE RECORDS YOU WANT TO DELETE". DELETE T.DISCOUNT_CODE, T.PART_ID, T.SELLING_UM, T.QTY_BREAK_1, T.QTY_BREAK_2, T.QTY_BREAK_3, T.QTY_BREAK_4, T.QTY_BREAK_5, T.QTY_BREAK_6, T.QTY_BREAK_7, T.QTY_BREAK_8, T.QTY_BREAK_9, T.QTY_BREAK_10, T.UNIT_PRICE_10, T.UNIT_PRICE_3, T.UNIT_PRICE_4, T.UNIT_PRICE_5, T.UNIT_PRICE_6, T.UNIT_PRICE_7, T.UNIT_PRICE_8, T.UNIT_PRICE_9, T.UNIT_PRICE_2, T.UNIT_PRICE_1, T.DEFAULT_UNIT_PRICE FROM SYSADM_DISCOUNT_PRICE AS T INNER JOIN D ON T.PART_ID = D.PART_ID; sql ms-access sql-delete share|improve this question edited Aug 9 '15 at 16:50 Brian Tompsett - æ±€è±æ© 3,091132775 asked Jul 15 '11 at 16:10 Nathaniel_613 1272728 add a comment| 3 Answers 3 active oldest votes up vote 1 down vote accepted MS Access does let you join on a delete. So you can write you DELETE statement like this without naming the columns. DELETE T.* FROM SYSADM_DISCOUNT_PRICE AS T INNER JOIN D ON T.PART_ID = D.PART_ID; share|improve this answer edited Jul 15 '11 at 17:58 answered Jul