Access to SharePoint Date/Time Conversion

All,

I've linked my Access 2007 database to a SharePoint 2007 list as a table. 

I'm using ADO to update the records in the list.  Everything works fine 
except when I try to update a date/time field in the SharePoint List.  I'm

using the Now() function in Access and I receive a Runtime " '-2147217887 
(80040e21)' The field is too small to accept the amount of data you
attempted 
to add.  Try inserting or pasting less data." error.

Does anyone know if I have to format the Access date/time value to a 
specific format for SharePoint to accept it?

Thanks in advance,

Matt