Link to home
Start Free TrialLog in
Avatar of jwandmrsquared
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).
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Can you open the list directly on the Sharepoint site and modify it?

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.
Avatar of jwandmrsquared
jwandmrsquared

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
Avatar of jwandmrsquared
jwandmrsquared

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Because I figured it out before an answer was provided.