Did you look up the error message in the ms access, search for box, it comes up with a number of things to check?
Hope one of them helps. I used the first part of the error message as follows. [ Syntax error in string in query expression ] also another search with just the last part of the error message. last part gave me the forum for questions. Address below. Sorry, I couldn't be of more help. Have a great day. Maybe this site will be of help. very long url just copy and paste into address bar. http://www.microsoft.com/office/community/en-us/wizard.mspx?query=Syntax+error+in+string+in+query+expression&cboDiscussionGroup=en-us-office-access%3A%3Aen%3AUS%3A327f343d-f0d6-4e07-aa53-9656edb98ada%3A%3A%3A&=Search+again&w=1&type=question&dg=&cat=en-us-office-access&lang=en&cr=US&pt=327f343d-f0d6-4e07-aa53-9656edb98ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us --- On Tue, 6/23/09, Joe <[email protected]> wrote: From: Joe <[email protected]> Subject: [Access VBA Central] Error Msg when trying to insert info into Access using VB To: [email protected] Date: Tuesday, June 23, 2009, 1:35 PM I'm using a tool that uses VB to insert data into an Access DB that it creates. I'm getting the following error msg when it's running. Syntax error in string in query expression"Dynamic_ Objects_Descript ions' Here's a link to the Error msg I'm getting. http://picasaweb. google.com/ joefonseca79/ WORK#53487867100 17105650 If anyone has a clue it would be a great help. [Non-text portions of this message have been removed]
