Link Access 2007 Database To Database. Prepare to link tables in an Access database. The Get External Data wizard starts.
To import forms reports or modules into an Access 2007 database you first convert the database by using an earlier version of Access then open the converted database by using Access 2007 and then convert the database into an Access 2007 accdb file format database. The process of linking to data in another Access database follows these general steps. I have an Access 2007 database cmyDbaccdb with a table named MASTER_TABLE that is linked to a table named TBLMASTER_TABLE in a DB2 database named PRODUCTION.
Locate the source database.
In this example we are selecting the Testing2accdb file. For Microsoft Access 2003 and earlier choose ODBC Databases from the Files of type list. I wish to use VBA to change a linked table from one Access 2007 database to another Access 2007 database. To import forms reports or modules into an Access 2007 database you first convert the database by using an earlier version of Access then open the converted database by using Access 2007 and then convert the database into an Access 2007 accdb file format database.