Hi All,

While we Open with access any List from Ribbon , a UserInfo Table gets created.I want to understand How the columns are getting exported in UserInfo list. Is there any settings I can check and decidde what to export and what to not.

Please suggest.

Thank You,

Hi Lalita- this is an automatic process. You'd have to make column changes in SharePoint in order for them to reflect in the table. Other than that, I don't think there's a way to pick and choose what gets sent to the table. Even if there was, as soon as it was refreshed, the table would revert back to all of the info. again. See the following link regarding structure changes:

https://support.office.com/en-us/article/Synchronize-a-SharePoint-2010-list-with-Access-2010-975bfb97-c799-4fce-b7cc-3db3b397f116?CorrelationId=70d00160-9ae4-4597-82b2-b3954441ed48&ui=en-US&rs=en-US&ad=US#__toc264537537