jwandmrsquared
asked on
Access using Sharepoint List not permitting updates to Memo fields
I have never attempted to connect Access to a sharepoint list, but necessity makes it so right now. I have created the list in sharepoint, but Access will not permit me to put information into the memo-type fields. Any ideas? I have Access 2010 and Sharepoint 2010 (I think - not even sure where to check the sharepoint version).
ASKER
I can add items directly into the sharepoint list, including those fields. When I open the linked table in Access, and attempt to enter data into that field, the bottom left of the screen tells me the field is read-only.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Because I figured it out before an answer was provided.
Note that "Long Text" (which is the Memo type in newer versions of Access) can be set to Append Only, which may cause troubles when moving to SP lists.