Microsoft access linked tables not updating
Xero offers authentication for private applications, public applications, and partner applications.
Follow the steps below to create a linked table, which enables you to access live Lists data.
Using the CData ODBC driver for Google Analytics, you can update live Google Analytics data in Microsoft Access; for example, you can make updates that can be immediately seen by other users.
If you have not already, first specify connection properties in an ODBC DSN (data source name). You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs. To access Google APIs on behalf on individual users, you can use the embedded credentials or you can register your own OAuth app.
In addition, you will need to specify a URL to a valid OData server organization root or OData services file.
Follow the steps below to create a linked table, which enables you to access live Orders data.