Inhaltsverzeichnis
2.1 Linked Tables in Access
Prerequisites
Instructions
Advantages
Limitations
2.1 Linked Tables in Access
Include data from the Gateway as linked tables.
Prerequisites
Access 2016 or newer
Network access to Gateway
Instructions
External Data
→
New Data Source
→
From Online Services
→
OData Feed
Enter
URL
:
http://server:5000/odata/demo
Select tables
Choose
As linked table
OK
Advantages
Data stays current
No data duplication
Queries and forms use live data
Limitations
Read-only (no writing via OData)
For write access: Use VBA