I have a Sharpoint Document Library with a couple of additional columns, two
of which are dates. When I link to that list from Access, and try to assign a
date to one of the date fields (using vba), I get a consistent message saying
the field is too small to hold the string I'm trying to assign to it.
I tried everything, using the NOW() function to ensure I was getting a good
date. I assigned it directly, formatted it as YYYY/MM/DD, YYYY-MM-DD,
MM/DD/YY, every possible incarnation of dates, and get the same error message
each time.
Any ideas?