Access 2003 Error 3125
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. Getting error " '' is not a valid name... [Error 3125] Expert 100+ P: 931 patjones Hi: I've got a backend database, with several tables linked together via one-to-many relationships, and a front end database that links to those tables. The problem is, when I attempt to look at the relationships from the front end, I get '' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. According to the help window, this is Error 3125. Any ideas? Thank you ... Pat Feb 19 '08 #1 Post Reply ✓ answered by patjones The problem turned out to be an apostrophe in a folder name that is part of the path to the back end file. Kind of dumb of me to use an apostrophe in a folder name I suppose. Be there it is for anyone else having the same issue! Share this Question 5 Replies Expert 100+ P: 931 patjones The problem turned out to be an apostrophe in a folder name that is part of the path to the back end file. Kind of dumb of me to use an apostrophe in a folder name I suppose. Be there it is for anyone else having the same issue! Feb 19 '08 #2 reply Expert 100+ P: 1,384 Scott Price LOL, as I've said before, programming gives all of us plenty of opportunities to do dumb things :-) Doesn't mean that we are dumb people! Thanks for posting back with what the problem was! Regards, Scott Feb 20 '08 #3 reply P: 1 Chicanoy hi zepphead80, Have the same problem. I am using Access 2007 which is link to Access 2003 table. You mention that "The problem turned out to be an apostrophe in a folder name that is part of the path to the back end file".. I know I have to remove the apostrophe BUT HOW?? is it in a code? VBA? or something else? I am just a beginner so please bear with me..
here for a quick overview of the site Help Center Detailed answers 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 Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Run-time error 3125 when exporting to Excel from Access up vote 0 down vote favorite I'm exporting a file from Access to Excel, using the following code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "" & https://bytes.com/topic/access/answers/772840-getting-error-not-valid-name-error-3125-a strQuery & "", "" & result & "", True strQuery is the name of the Query that the exported file is based on, and result is the file name and address, gained from a Save As dialog. There are two potential queries I'd want to use, depending on the user's search criteria. When using the first query, Report, it works fine. When using the second query Report2, it throws up an error: Run-time error '3125' '' is not a http://stackoverflow.com/questions/5714026/run-time-error-3125-when-exporting-to-excel-from-access valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. The Report2 query works fine when run by itself, and as part of a subform, just not on this export. Any ideas as to what I'm doing wrong? Thanks in advance. ms-access ms-access-2007 runtime-error share|improve this question asked Apr 19 '11 at 9:06 BFWebAdmin 2,11863166 1 Try getting rid of the quote marks around the query text, you should not need them. So it should now read DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, strQuery , "" & result & "", True. If that fails try a hard typed export path –Kevin Ross Apr 19 '11 at 10:47 Thanks - but ultimately it seems to have been a problem with the query rather than the code above. I've rebuilt the query from the ground up and things appear to be working now, –BFWebAdmin Apr 19 '11 at 11:30 add a comment| active oldest votes Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook. Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Browse oth
Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 05-08-2009, 01:46 PM http://www.access-programmers.co.uk/forums/showthread.php?t=171676 #1 Kila Newly Registered User Join Date: Mar 2003 Posts: 275 Thanks: 0 Thanked 1 Time in 1 Post Error 3125 after opening 2003 db in 2007 I have a database that worked fine in http://www.tek-tips.com/viewthread.cfm?qid=1525987 Access 2003. Now in Access 2007 I am getting this error when I try to view a query a form is based on: Quote: This is not a valid name. Make sure it is a valid parameter or access 2003 alias name, that it does not include invalid characters or punctuation, and that the name is not too long. (Error 3125) The specified name does not follow standard naming conventions or is not a valid parameter or alias name. Check your entry to make sure you have not included invalid characters or punctuation and that the name is not too long. The field in the form WAS based on the following SQL: Code: SELECT tblRoster.ActionID, tblDepartments.Department, access 2003 error tblActions.DateEnd, tblActions.DateStart, tblActionList.Action, tblRoster.Service, tblRoster.RosterID, tblRoster.NameID, tblRoster.RotationStart, tblRoster.RotationEnd, tblRoster.RotationID, tblRoster.LastLogin, tblRoster.Comment, tblRoster.New, tblRoster.CommentID FROM ((((tblRoster LEFT JOIN tblRotations ON tblRoster.RotationID = tblRotations.RotationID) LEFT JOIN tblCommentType ON tblRoster.CommentID = tblCommentType.CommentTypeID) LEFT JOIN tblActions ON tblRoster.ActionID = tblActions.ActionID) LEFT JOIN tblActionList ON tblActions.ActionListID = tblActionList.ActionListID) LEFT JOIN tblDepartments ON tblActions.DepartmentID = tblDepartments.DepartmentID ORDER BY tblRoster.RotationStart DESC; I would not have written this myself, as I am only now learning SQL as it pertains to queries. I developed this db awhile back, but this would have been created in design view in the query builder or as a separate query. I tried to make this a seperate query, and even attempted to recreate it from scratch as a new query, but to no avail. When I tried to create it anew, I got a similar message as I added many of the tables to the query. What could it be about these tables that is too long now that was not too long in Access 2003? Is there a shorter limit on the length of fieldnames? Just as an FYI, I CAN run the query or look at it in SQL view, I just cannot view it in design view. Any assistance you can offer would be appreciated. Thanks! Last edited by Kila; 05-08-2009 at 01:48 PM. Reason: Left out info Kila View Public Profile Find
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Other topics Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Other topics Forum Can't open my queries in Design View thread181-1525987 Forum Search FAQs Links MVPs Can't open my queries in Design View Can't open my queries in Design View 347pg (TechnicalUser) (OP) 22 Jan 09 17:44 I developed a db with tables and queries which I then exported to another db.The tables have no issues.I was able to open up both tables and queries in Design View in the first db, but in the second one I get an error.The queries run ok in the second db, butI can't view them to alter.I did not link them to the first db but exported.The error I get says:"is not a valid name.Make sure that it does not include invalid characters or punctuation and that it is not too long.(exactly like that, Access put the leadin " mark in there).When I select help, the following appears.This is not a valid name. Make sure