Sie befinden sich hier: start » en » Internal Documentation » WvdS Data-Gateway » 3. User » 2. Access » 2.1 Linked Tables in Access

Inhaltsverzeichnis

2.1 Linked Tables in Access

Include data from the Gateway as linked tables.

Prerequisites

  • Access 2016 or newer
  • Network access to Gateway

Instructions

  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

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
Zuletzt geändert: on 2026/01/29 at 11:23 PM

Seiten-Werkzeuge