Error trying to search a database table

[pandu101]

I am trying to run the following query that will look for events with a particular date in a table. The date is saved as a string in the database (SQL 2005). But I get an error stating "Incorrect syntax near 'Sunday" on the following line (the second one).

start_date = "Job started: Sunday, September 26, 2010 at 11:00:03 AM"

objRS.Open "SELECT * FROM tbl_Backup_Jobs WHERE start_date = "&start_date,objConn,3,3

I cant figure out how to get around this error. TIA.

 

[PHV]

objRS.Open "SELECT * FROM tbl_Backup_Jobs WHERE start_date = '" & start_date & "'",objConn,3,3

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886