Access updating linked tables
Suppose a database application consists of the following two files: Students Db_(the front end) and Students (the Back end) . The linked table manager will now prompt you for the location.The file Students Db.mdb( viz the Back end) is installed in the computer which has the identification Newpc on the network . Our back end database is installed in the folder C:\ My Documents of the computer which has the identification Newpc on the network . From Network Neighborhood we have to select Newpc and locate the folder C:\ My Documents.In such cases the front end and backend are separate files .The backend is installed on one computer and the front end is installed on one or more computers as per requirements.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.In many small offices Access is used as the database.
Then in the Import group, click on the button and select ODBC Database from the popup menu.
If Integrated Security is set to false, then User and Password must be set to valid user credentials.
Optionally, Database can be set to connect to a specific database.
Select the option called "Link to the data source by creating a linked table" and click on the OK button. Click on the Machine Data Source tab and select the ODBC connection for your Oracle database. Enter your user name and password for the Oracle database. Now you can select the Oracle tables that you wish to link to.
In this example, we have chosen an Oracle database called "Prod".
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.