access db date parameter error

[Mr. x]

Hello,
I am using access database in aspx.
I did something like this :
....
currParam = new oleDbParameter("@create_date", OleDbType.DBTimeStamp)
currParam.value = Now
cmd.parameters.add(currParam)

In the sql I wrote :
insert into mytable ( ... , create_date , ....)
values( ..., @create_date, ...)

When execute the query I get an error :
Data type mismatch in criteria expression.

What is the problem ?

Thanks :)

[Frogbèrt]

"Mr. x" <a@b.com> wrote in message news:3f511bd6@news.012.net.il...

> Hello,
> I am using access database in aspx.
> I did something like this :
> ...
> currParam = new oleDbParameter("@create_date",

OleDbType.DBTimeStamp)

> currParam.value = Now
> cmd.parameters.add(currParam)

<snip>
Format your currParam using the proper identifier (mind the wrap):

currParam.value="#" & FormatDateTime(Now) & "#"

HTH
Robert