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