Why do I get 'Syntax Error in INSERT INTO Statement' with Access?

Aside from an actual syntax error in your SQL statement, such as a misplaced quote, comma or bracket, the most common cause for this error is by using a reserved word as an alias, column name or table name. For a list of reserved words to check against your statement, see: 
 
    Article #2080 
 
There is one word that keeps cropping up as the source for this error -- at least in Access -- though it is not documented in the above article: password. 
 
If you cannot change the name of the column that is using this reserved word, wrap it in [] brackets. E.g.: 
 

SELECT password FROM users

 
becomes 
 

SELECT [password] FROM users

 
Next, check your delimiters. You might get this if you try to delimit a numeric field with an apostrophe or quote, or a date column with the wrong delimiter, or leave a string without a delimiter. 
 
Finally, if you're still having a problem, change: 
 

<%      conn.execute(sqlString)  %>

 
to: 
 

<%      response.write(sqlString)  %>

 
That should point out the problem. If it doesn't, post your code, the resulting SQL, and your data structure to microsoft.public.inetserver.asp.db and someone will try and help you.