Can you switch to SQL view on these "bad" queries? If so, is the SQL correct? Paste an example in a reply here. It might be the case that your queries in 2003 are using some name that is now reserved in 2007 - and you'll need brackets around the name.
John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access Applications Microsoft Office Access 2003 Inside Out SQL Queries for Mere Mortals http://www.viescas.com/ (Paris, France) For the inside scoop on Access 2007, see: http://blogs.msdn.com/access/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of lk_maxwell Sent: Thursday, August 23, 2007 1:35 AM To: [email protected] Subject: [ms_access] is not a valid name error for queries in Access 2007 I have recently upgraded to Access 2007 and many of my queries get the following error: "is not a valid name. Make sure that is does not include invalid characters or punctuation and that it is not too long. There is no name in front of the "is not a valid name" portion, just the quotation mark. Everything works fine in 2003 and when I create a new 2007 database and import those queries, I get the same error. I am running Windows XP. Has anyone else seen this and is there a fix? Yahoo! Groups Links
