Forum Discussion

CharlesDK's avatar
CharlesDK
Copper Contributor
Jun 29, 2021

Force Access DB out of read-only mode

In order to use Task Scheduler to update a SharePoint Online list from Excel, which it doesn't seem possible to do directly using VBA, I am trying to update via an Access DB linked to the SP list. An...
access
sharepoint
George_Hepworth's avatar
George_Hepworth
Silver Contributor
Jun 29, 2021

CharlesDK 

It sounds like you have at least two different, albeit related problems.

Before attempting to sort it out, though, we need a bit of clarification.

 

HOW did you create the SharePoint list in the first place?
HOW did you link the Access accdb to that SharePoint list?

Does the SharePoint list have a field defined as a Primary Key, i.e. a unique identifier? If so, what is that field and what datatype is it?

I suspect that the "Person or Group" field in your SharePoint list is actually defined in SharePoint as a Lookup field. If so, it really IS a number and that number is actually the Foreign Key from whatever SharePoint list it gets the Person or Group values. Please confirm that. The issue as to whether it is required or not is going to be determined by some of the other factors we identify, but my guess is that SharePoint and Access have agreed that it is, in fact, required and you just need to figure out why.

Resources