CodeDocu.com

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)
Include SharePoint Lists in MS Access
 
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.
Include SharePoint Lists in MS Access
 
Then you select several lists by checkbox field.
Include SharePoint Lists in MS Access
 
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
Include SharePoint Lists in MS Access
 

Software Entwicklung Stuttgart NĂ¼rtingen
Suche Projekte C#, WPF, Windows App,ASP.Net, vb.Net, WinForms, SQL Server, Access, Excel