Freelance Project Requests info@CodeDocu.de Software Development in C# WPF Asp.Net Core Vba Excel Word SQL-Server EF Linq, UWP Net
#

Include SharePoint Lists in MS Access
 
Under Microsoft Access, you can directly bind SharePoint lists from SharePoint Online and the on-Premise Framework as bound datalists.
After that you can edit the data directly here.
 
How to include SharePoint lists in Access
 
Connect SharePoint Server
Access->Menu->External Data->New Data Source ->From Online Services->SharePoint List
(Import SharePoint List)

 
In the dialog: External Data: SharePoint Site
->specify the SharePoint Server
So https://meineFirma.SharePoint.com
 
The option: Create eine  link to the data source
Causes the table to be actively connected reading and writing.

 
Then you select several lists by checkbox field.

 
SharePoint Lists as Tables
After that, the lists in Access are available under Tables.
Double-clicking a list opens it as a connected table from the external server.
the table is then write and read active and can then be further processed for forms and queries

 
Mobile
»
How to debug a webpart in VS Code with the Microsoft Browser
»
Automatically update SharePoint WebPart from Visual Studio Code
»
Deploy SharePoint WebParts automatically
»
Include SharePoint Lists in MS Access

.

Contact for Jobs, Project Requests: raimund.popp@microsoft-programmierer.de