Access 2007 Reserved Error 1038
Ask a Question Need help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. Uggg Help with Reserved error -1038 - not Access 97 P: 4 mallegirl I have been using a bit of great code and SQL I found on this site and it has worked fantastic but all of a sudden i am getting this error message. " Reserved error (-1038): there is no message for this error." All i can find about the error is that it has to do with access 97 but i have 2002 and never had this db on a computer with access 97. I think i might go crazy if i can get this to work. I am new to this whole site but here is the URL to the original post i was working from. Dec 2 '08 #1 Post Reply Share this Question 6 Replies P: 4 mallegirl Combining Multiple Rows of one Field into One Result Dec 2 '08 #2 reply Expert 100+ P: 2,364 Dököll @mallegirl Glad to hear we have helped you solve some issues, mallegirl... please continue paying us a visit now and then. I am not sure what may be happening. I will however send you over to our gurus in VBA to see what could be salvaged for ya. Sorry for your troubles:-) Dec 3 '08 #3 reply P: 4 mallegirl I appreciate you taking the time to respond. I actually figured out how to make it work. The solution uses Max(concat(group, item) but for some reason that wont work for me. I changed it to last(concat(group, item)) and now it is working again. Dec 3 '08 #4 reply Expert Mod 15k+ P: 29,922 NeoPa Check out the linked thread again (You should be subscribed already). I have highlighted two posts which indicated that the OP had a similar problem to yours, as well as finding the same "solution". Dec 3 '08 #5 reply P: 1 vissas Hi, I cut and paste the code and works perfectely fine (ofcourse I have to use last and not max). Really appereciate the solution. Thanks!!!! Feb 15 '10 #6 reply Expert Mod 15k+ P: 29,922 NeoPa Thanks for letting us know :) Another related link - direct to th
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Tech Advisors Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask https://bytes.com/topic/access/answers/857216-uggg-help-reserved-error-1038-not-access-97-a a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Run-time error '3000': Reserved error (-1038); There is no message for this error. Microsoft ISV Community Center > Visual Basic for Applications (VBA) Question 0 https://social.msdn.microsoft.com/Forums/en-US/2da409ca-8ed0-4f3d-b71d-0561229297e1/runtime-error-3000-reserved-error-1038-there-is-no-message-for-this-error?forum=isvvba Sign in to vote Hi all,  New problem to me, the above error occurs on the seek method below. My PrimaryKey is correct. Cannot see the problem any ideas?  Private Sub btnBuildLastMoved_Click()Dim rsPart, rsLastM, rsSQL As DAO.RecordsetDim lngSI As LongDim strSQL As String Set rsPart = CurrentDb().OpenRecordset("Part Table")Set rsLastM = CurrentDb().OpenRecordset("tbl Last Moved", dbOpenTable)rsLastM.Index = "PrimaryKey"    While Not rsPart.EOF       strSQL = "SELECT DM9ADTA_F4111.ILITM, DM9ADTA_F4111.ILMCU, DM9ADTA_F4111.ILDCT, Max(DM9ADTA_F4111.ILDGL) AS [Julian Last] " & _                "FROM DM9ADTA_F4111 " & _                "GROUP BY DM9ADTA_F4111.ILITM, DM9ADTA_F4111.ILMCU, DM9ADTA_F4111.ILDCT " & _                "HAVING (((DM9ADTA_F4111.ILITM)=" & Trim$(Str$(rsPart![PS Item])) & ") AND ((DM9ADTA_F4111.ILDCT)<>'IB' And (DM9ADTA_F4111.ILDCT)<>'IZ' And (DM9ADTA_F4111.ILDCT)<>'IT'));"       Set rsSQL = CurrentDb().OpenRecordset(strSQL)       If rsSQL.RecordCount > 0 Then           Me.Status = rsSQL!ILITM           Me.Repaint           Me.Refresh           While Not rsSQL.EOF               rsLastM.Seek "=", rsSQL!ILITM, Trim$(rsSQL!ILMCU), rsSQL!ILDCT               If rsLastM.NoMatch Then                   rsLastM.AddNew                   rsLastM!ILITM = rsSQL!ILITM      Â
ManagementDevelopment ToolsSystem AdministrationApplication Building BlocksDownloadsDocumentationContinuous Software ManagementLicensingPlatform AvailabilityAddonSoftware ERPBASIS Transformer AMISalesSales Overviewb‑commerceHow to BuyPartnership ProgramSolutionsSolutions OverviewTraining/TutorialsDemo ShowcaseDownloadsProfessional ServicesSupportSupport OverviewFAQsKnowledge BaseDiscussion ForumsTech Support PolicyEventsEvents OverviewTrainingJava Break http://www.basis.com/kb00509 ArchivesTechCon2015About UsBASIS OverviewContact UsThe BASIS Advantage MagazineAnnouncementsPress ReleasesManagementLegalMaps and DirectionsLogosLiterature Support Overview FAQs Knowledge Base Discussion Forums Tech Support Policy The BASIS AdvantageCurrent IssuePrevious Issues You are hereHome KB#00509-Reserved error (-7778) in Access when connecting to a ODBC data source Title: Reserved error (-7778) in Access when connecting to a ODBC data source Description: When linking access 2007 to a data source in Access, the following error may result: Reserved error (-7778); there is no message for this error. Resolution: This error occurs when the File Data Source is selected from Access. If the data source is selected from Access' Machine Data Sources tab, then the error will not occur. Microsoft Query, on the other hand, does access 2007 reserved not have this problem. In fact, MSQuery 8 (Shipped with Office 97) requires that the data source be under File DSN; otherwise it does not list it. As MS Word and Excel both use MS Query for ODBC Access, they will require that the Data Source be defined as a File DSN. Note that it is ok to have the data source defined both as a User DSN and as a File DSN from the Windows ODBC Administrator. If the data source is to be used with Access or MS Query 2.0, then a User or System Data Source must be created. If the data source is to be used with MS Query 8.0 (and therefore Word 97 and Excel 97), a File Data Source must be created. The easiest way to have both types of DSNs is to first create a User DSN. The next step is to create a File DSN that doesn't contain any configuration information - just a pointer to the User DSN that you just creat