Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  ASP/SQL/Access problem

Author  Topic  rgreen Starting Member 2 Posts Posted - 2001-10-10 : 17:20:22 I have seen many posts with a similar problem, but none of the culprits apply to my situation. My ASP code includes the following: sql_query = "Select TextureID from IDs where 3DModelID = 11" Set RS = myConn.Execute(sql_query) I'm sure that 3DModelID is a number, and not a text field in the database, so the issue is not about single quotes. The error I get is as follows: Error Type: Microsoft OLE DB Provider for ODBC Drivers 0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '3DModelID = 11'. /dbTest_backup2.asp, line 45 Looks like an easy one, but I'm out of ideas... Help would be appreciated. -Rachel