ADO with Access Date/Time field not storing the time, just the date
I'm using VB 6 and ADO to add records to a table. The table
has a Date/Time field.
All works fine, except that when I insert the record, ONLY
the Date is being stored..
e.g. If I use a value such as #01-Mar-2001 12:34# then
after the update, I look in the table and it has been
saved as 01-Mar-2001. My ADODB.Parameter object DOES have
the time stored when I Execute the Insert().
I've tried CDbl()'ing the Date but still no good...
I'm sure this worked fine with Access 97 a few weeks ago...