2.1 Linked Tables in Access

Include data from the Gateway as linked tables.

• Access 2016 or newer
• Network access to Gateway

1. External Data → New Data Source → From Online Services → OData Feed
2. Enter URL: http://server:5000/odata/demo
3. Select tables
4. Choose As linked table
5. OK

• Data stays current
• No data duplication
• Queries and forms use live data

• Read-only (no writing via OData)
• For write access: Use VBA