Access Web 2010 - accessing Sharepoint Author and Modifier

[OldMike]

We're running an Access 2010 web database.

As expected when we published to Sharepoint additional fields were added to the Access tables [App Created By] and [App Modified by]. We want to use these fields for Audit information however they are always empty. How should they be populated?

 

[trekingalong]

Open the table in MS Access. Right-click on a column heading. Select unhide fields. Check the box next to the field you desire.

 

[OldMike]

Thanks for that, this gives access to the information that I need, i.e. Sharepoint Author, Editor, CreatedDate and ModifiedDate. Though I am left wondering what the App Created By and App Modified By fields are meant to hold - these always appear without any data, while the Sharepoint fields are populated with the information that I need. Thanks again

 

[trekingalong]

I think these fields may be specific to your table. If you want to get rid of them, go into Site settings for your SharePoint site, on the left navigation bar, click All Site Content. A page will open and display the tables (called lists in SharePoint) in your database. Click on a table. A page will open displaying the table similar to what you see in Access. Go to the top menu a click the "List" tab under List Tools. Select modify view. A page will appear allowing you to select the columns to appear in your SharePoint list. The columns you choose will be downloaded to Access.