When I use OLE DB to connect to my access database I keep getting an error on a simple SQL statement. When I run the same SQL with ODBC I do not receive an error. Are there specific ways to write SQL for OLE DB? Is there somewhere I can look up the OLEDB Error Code? SQL: OLEDB Error Code = -529993134 Syntax error in INSERT INTO statement. SQL = "INSERT INTO action_log ( emp_number , action ) VALUES ( 8908 , 'Assign' )" Data Source = "OLEDB_IMS_LOCAL" emp_number is a numeric only field action is an alpha-numeric field Thanks, Jim Christiano Clearwire Technologies, Inc. ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
