Brendan,
Unfortunately, I wasn't lucky enough to have made that mistake. I did
have
the columns set to date/time format. I did some playing around and found
a
work around. Access stores date/time in double integer format. It just
converts the number to a date/time when it displays it. So, with that in
mind, I converted all of my date/time columns in the SharePoint list to
number columns and it worked!
The only drawback is that SharePoint will only display it in the raw
number format. So, if you plan to manipulate the date/time data in
SharePoint, this probably isn't the solution. But, if you are stricktly
using the data in Access, this did the trick!
Thanks for your help and I hope someone else can use this info to save
them
a lot of heartache
Matt
"Brendan Reynolds" wrote:
> "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
>
|
