Problem updating a Date value into Access DB

From: jtrainaldi@xxxxxxxxx
Date: 5 Dec 2006 11:50:59 -0800

I have tried everything with updating a database record and it still
errors on the date.

I have tried the following
SQL_query_courseUpd = "UPDATE courses SET date = '#" & date1 & "#'
WHERE courseID = '" & courseID & "'"

SQL_query_courseUpd = "UPDATE courses SET date = #" & date1 & "# WHERE
courseID = '" & courseID & "'"

SQL_query_courseUpd = "UPDATE courses SET date = " & #date1# & " WHERE
courseID = '" & courseID & "'"

Which ones am i missing?

Thank you

.

Follow-Ups:
- Re: Problem updating a Date value into Access DB
  - From: Bob Butler

Prev by Date: Re: rtrim not working.................. -_-
Next by Date: Re: Problem updating a Date value into Access DB
Previous by thread: Re: Access caching problem?
Next by thread: Re: Problem updating a Date value into Access DB
Index(es):
- Date
- Thread