Access updating linked tables
Using the CData ODBC driver for My SQL, you can update live My SQL data in Microsoft Access; for example, you can make updates that can be immediately seen by other users.
The Server and Port properties must be set to a My SQL server.
The database application is created by using Access as the front end (The part of the database application which has the User interface , Data entry forms, Reports etc) as well as the backend (The part of the database application which has the data) of the database application.Using the CData ODBC driver for JSON, you can update live JSON services 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.You are able to link to tables from other databases, whether the table is an Access table, an Oracle table, an Excel spreadsheet, or even a text file.To link to a table from another Access database, select the External Data tab in the toolbar at the top of the screen. Next, click on the Browse button and find the Access file that contains the tables that you wish to link to.
Search for access updating linked tables:
When you have finished selecting the tables, click on the OK button.