Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

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).
0
jwandmrsquared
Asked:
jwandmrsquared
  • 3
1 Solution
 
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
 
jwandmrsquaredAuthor Commented:
Because I figured it out before an answer was provided.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now