Link

On the File tab, in the Data File group:

  • Select Link | ODBC to establish a link to a table in an external database.

  • Once you have established the link, the data in the corresponding data file will only be refreshed when you right-click and select Reload ODBC link when you load the file into a form. Alternatively: Select Link | ODBC Link Update to run a macro to update one or more ODBC links.

  • Select Link | Microsoft Access Link to establish a read-only link to a table in an external Microsoft Access database.

  • Select Link | Microsoft Access Link Update to run a macro to update one or more Microsoft Access Database (MDB) links.