"Matt" <Matt@[EMAIL PROTECTED]
> wrote in message
news:4B549ECF-E9E7-4586-AD53-E1B7C9948B65@[EMAIL PROTECTED]
> 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
I'm not a SharePoint expert, by any means, but when you create a date/time
column in SharePoint, you can specify that the column allows a date and
time, or a date only. The default is date only. So you might want to check
the setting for that column in SharePoint, or try using Date() instead of
Now(), or formatting the date to remove the time part.
--
Brendan Reynolds
|
