Hey.
Try using " instead of #
I am using ADO to insert data into a DateTime field in Access at the moment, and I do
"01/07/2000"
Try that.....From memory, the # is used when doing a select only, and when doing an
insert or an update, you use "
Jeremy
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
- [DUG]: access Mark Derricutt
- RE: [DUG]: access vss
- RE: [DUG]: access Mark Derricutt
- Re: [DUG]: access Matthew Comb
- Re: [DUG]: access Mark Derricutt
