====== 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