Force Access DB out of read-only mode

Hi,

I'm not sure to understand your situation. So, if you don't get helpful answers it might be good to describe step by step what you did to create the Access file, where it is, if the complete file, the table or only the Person field is not editable, how you linked the Sharepoint list etc.

Generally said:

The data type of the Person field has to be a number of type Long in Access because it is the same in Sharepoint. This column refers to the ID column in the UserInfo list of Sharepoint. Normally when you link a Sharepoint list in Access which contains a Person field the UserInfo list is linked automatically too and the lookup relationship that exists in Sharepoint is also created in Access. Access then shows a combo box in the linked table/list to let you choose a person (or group) by name instead of ID.

If you don't see the names but numbers in the column/combo box then it may be that your Access db is missing the UserInfo list. In this case you can try to right click on the linked table in the navigation pane of Access and choose More Options and Refresh List. This should link the UserInfo list, create the relationship and let you see and choose the person names in the combo box.

Servus
Karl
*********
http://AccessDevCon.com
https://www.donkarl.com