Sharing/Linking Tables between Access Databases
Note: with theedition you can open up to 3 templates concurrently on the same computer; The edition does not have this limitation.
With the multiple templates/databases configuration, it might be necessary to share database tables between databases. For example, you might want to able to update the customer or product list only once and have the updates appear in more than one databases and be available in all the related templates.
This can be accomplished by linking tables between Microsoft Access databases. The following tutorial assumes you have two databases,and , and two invoice templates, and are connecting to the two databases respectively. will contain real data, and contains only a linked table. Your updates to table via either template will be visible in both databases and templates.
- First of all, backup your database files in Windows Explorer, so that you can easily restart again in case something is wrong during the process.
- Double-click , the database which will contain the linked table, to open it in Microsoft Access.
- In the list, click and select the table. Press the key on your keyboard to delete it.
- In Access 2007, click "
In Access 2003, click Access menu-> -> , and then browse to and open the source database (in this case, ).
" on the " " group on the " " ribbon tab. Specify the source database path and name (in this case, ), choose " ". Click .
- On the dialog box, choose table and click .
Thedatabase table can be shared in the same way.
With this setting, updates you make to(via ) are actually made in the , and the updates are visible via both templates.