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).
jwandmrsquaredAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
jwandmrsquaredAuthor Commented:
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.
0
jwandmrsquaredAuthor Commented:
I used the "open with Access" feature in Sharepoint and suddenly the locks were gone.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jwandmrsquaredAuthor Commented:
Because I figured it out before an answer was provided.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.