the Manx Man's MS Access Pages

How to Get Data from another Access Data Base (011)

If you need to read and/or update data in a second Access database without living the first one, just link to it.

In the File menu there is a Get External Data command. Under this is a Link command. Once you have linked to a table in another mdb you can treat it as if it is in your current mdb. Add to it, delete from it, change data in it. You just cannot change its design.

One word of caution. If the other data base gets moved, the link is lost. If this happens, you can delete the link and re-build it. If you have several links from the same mdb, use the Linked Table Manager under the Tools / Add-In menu to change them all at once. If you did a default install of Access you will not have this add-in and will have to re-install.