Cannot update Sharepoint list

[Isaac]

I've never been able to update a Sharepoint list from Access, where in the row I'm trying to update, there's a column that's of type PEOPLE

 

[GPGeorge]

I've never been able to update a Sharepoint list from Access, where in the row I'm trying to update, there's a column that's of type PEOPLE

Interesting, I'll have to try that. But is PEOPLE a multi-value or choice data type? Or what we might call normal datatypes in other databases?

 

[GPGeorge]

Interesting, I'll have to try that. But is PEOPLE a multi-value or choice data type? Or what we might call normal datatypes in other databases?

Or did you mean "Person or Group"? Or something else? SharePoint is a different environment.

 

[Isaac]

Interesting, I'll have to try that. But is PEOPLE a multi-value or choice data type? Or what we might call normal datatypes in other databases?

I've always thought of it as its own special sharepoint beast - probably Access considers it multi value I would think

 

[Isaac]

Or did you mean "Person or Group"? Or something else? SharePoint is a different environment.
View attachment 121032

Person or Group, yeah

 

[MajP]

I bet People displays a person name, but it is pulling data from the exchange server so I bet it is actually storing some kind of exchange ID. So I would think it is a kind of lookup field.

 

[GPGeorge]

I bet People displays a person name, but it is pulling data from the exchange server so I bet it is actually storing some kind of exchange ID. So I would think it is a kind of lookup field.

Yes, that's why I was being nitpicky. It refers to someone in that SharePoint tenant. If it is a required field, and I think that's optional, then that might account for the error.

 

[LarryE]

Thank you. We will all miss UA.

Right now, we have summer weather in Western Washington. In two weeks? Anybody's guess.

From Aberdeen originally George. Left in 1970. Different place now.