Linking SharePoint and Access database

Flinn, Randal J 281 Reputation points
2022-05-23T13:19:05.62+00:00

Hello,

I am attempting to link a SharePoint list to Access. The only issue I am currently having is related to the SharePoint "Created By" and "Created" fields. To minimize the data entry by individuals, I am using the Created By and Created fields to identify who entered the record and on what date. When I link the SharePoint List to Access, these fields do NOT appear in the Access table.

Recognizing these are not editable fields, is there a way to include these in the link?

Thanks

Microsoft 365 and Office | SharePoint | For business | Windows
{count} votes

Answer accepted by question author
  1. Emily Du-MSFT 51,941 Reputation points Microsoft External Staff
    2022-05-24T06:30:35.703+00:00

    @Flinn, Randal J

    Please right click the header in the Access table -> Select the "Unhide Filters" -> Choose "Created By" and "Created" fields.

    204946-1.png

    204800-2.png

    204971-3.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.