Ms Access Reserved Error 3087
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) Home20132010Other VersionsLibraryForumsGallery Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Reserved Error (-3087) Microsoft Office > Office 2010 - IT Pro General Discussions Question 0 Sign in to vote Access DB Reserved Error (-3087) and the messages is fun. Thanks & Regards, Santhosh Wednesday, March 07, 2012 6:46 AM Reply | Quote Answers 0 Sign in to vote Based on my research, this error could occur when any of the following is true: a.There are reserved words used.b.You’ve grouped complex queries To solve the error, try the following: For situation a. If a reserved word is already in use, you can avoid this error message by surrounding each occurrence of the word with brackets ([ ]). However, the best solution is to change the name to a nonreserved word. For situation b. Ungroup these complex queries, create append query on a temporary table instead to workaround this issue. For your reference: Access 2007 reserved words and symbols http://office.microsoft.com/en-us/access-help/access-2007-reserved-words-and-symbols-HA010030643.aspx Note: It is not practical to provide a list of all reserved words, such as built-in function names or user-defined names. If you set a reference to a type library, an object library, or an ActiveX control, that library's reserved words are also reserved words in your database. Max Meng TechNet Community Support Edited by Max MengMicrosoft contingent staff, Moderator Sunday, March 11, 2012 7:49 AM Marked as answer by Jaynet ZhangMicrosoft contingent staff, Moderator Thursday, March 15, 2012 1:26 AM Sunday, March 11, 2012 7:47 AM Reply | Quote Moderator Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? Privacy statement © 2016 Microsoft. All rights reserved.Newsletter|Conta
Custom Search UtterAccess Forums>Microsoft Access>Access Queries Reserved error (-3087) with make-table query 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|-- https://social.technet.microsoft.com/Forums/office/en-US/01acbbd6-d61b-4f27-adf3-b4669d87b796/reserved-error-3087?forum=officeitproprevious 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 http://www.utteraccess.com/forum/index.php?showtopic=1943869 (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 tinkythomasView Member Profile Apr 29 2010, 03:44 PM Post#1Posts: 538Joined:
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss http://stackoverflow.com/questions/20058114/3087-error-in-access-2007 the workings and policies of this site About Us Learn more http://www.mrexcel.com/forum/microsoft-access/482452-access-error-code-3087-a.html 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 Community Stack Overflow is a community of 6.2 million programmers, just like you, helping ms access each other. Join them; it only takes a minute: Sign up -3087 error in Access 2007 up vote 1 down vote favorite I have the following code: SELECT Count(personnel.Position) AS countofposition, personnel.Position, Year(DateAdd("m",-6,[Personnel.End_Date])) & "-" & Year(DateAdd("m",6,[Personnel.End_Date])) FROM personnel GROUP BY Year(DateAdd("m",-6,[Personnel.End_Date])) & "-" & Year(DateAdd("m",6,[Personnel.End_Date])); and i get the "Reserved error (-3087); there is no message for ms access reserved this error" message I've checked the list of reserved words and I'm pretty sure I haven't used any. Rhe only thing I can think of is that the "Year" in "Year(DateAdd.... blahblahblahblahblah)" is messing me up Edit: Also, personnel.position is a multi valued field Thoughts? sql ms-access ms-access-2007 share|improve this question edited Nov 18 '13 at 21:39 asked Nov 18 '13 at 21:17 user2954166 133 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote I think this is what you're looking for: For table [Personnel] with multi-value field [Position]: ID FirstName LastName Position End_Date -- --------- -------- -------------- ---------- 1 Gord Thompson CTO, President 2013-11-01 2 Anne Elk Vice-President 2013-11-01 3 P. T. Gumby Vice-President 2013-11-01 the query SELECT Count(Personnel.Position.Value) AS CountOfPosition_Value, Personnel.Position.Value, Year(DateAdd("m",-6,[Personnel.End_Date])) & "-" & Year(DateAdd("m",6,[Personnel.End_Date])) AS Expr1 FROM Personnel GROUP BY Personnel.Position.Value, Year(DateAdd("m",-6,[Personnel.End_Date])) & "-" & Year(DateAdd("m",6,[Personnel.End_Date])); returns CountOfPosition_Value Personnel.Position.Value Expr1 --------------------- ------------------------ --------- 1 CTO 2013-2014 1 President 2013-2014 2 Vice-President 2013-2014 share|improve this answer answered Nov 18 '13 at 22:58 G
Forums Microsoft Access Access Error Code : 3087 Results 1 to 4 of 4 Access Error Code : 3087This is a discussion on Access Error Code : 3087 within the Microsoft Access forums, part of the Question Forums category; I am trying to run one of my database and getting an error : "Reserved Error (-3087); there is no ... LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jul 20th, 2010,01:44 PM #1 SKV Board Regular Join Date Jan 2009 Posts 249 Access Error Code : 3087 I am trying to run one of my database and getting an error : "Reserved Error (-3087); there is no message for this error" Any idea why this error is coming? I am not able to run my queries. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 20th, 2010,03:21 PM #2 Joe4 MrExcel MVPModerator Join Date Aug 2002 Posts 34,804 Re: Access Error Code : 3087 I found a description on the Microsoft site, but it does not appear to be much more helpful: http://support.microsoft.com/kb/186543 When exactly do you get this error? Can you open the database at all? Does the error just occur when running certain queries? Share Share this post on Digg Del.icio.us Technorati Twitter TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder. "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!" Reply With Quote Jul 20th, 2010,05:47 PM #3 SKV Board Regular Join Date Jan 2009 Posts 249 Re: Access Error Code : 3087 The error comes when I run append query while grouping records. I am able to open the database but not able to run append queries. Originally Posted by Joe4 I found a description on the Microsoft site, but it does not appear to be much more helpful: http://support.microsoft.com/kb/186543 When exactly do you get this error? Can you open the database at all? Does the error just occur when running certain queries? Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 20th, 2010,08:46 PM #4 Joe4 MrExcel MVPModerator Join Date Aug 2002 Posts 34,804 Re: Access Error Code : 3087 Perhaps you are using a reserved word as a field name or alias in your query. I did a Google search on "access error 3087 append query" and came across a few instances of this. If you cannot figure it out, post your query here (change your query to SQL view