Step by step to linking and importing database objects, especially where files have been moved from their original location.

Hello Alexandra,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding Linking and importing databases.

IMPORTING OBJECTS
Open a database, or switch to the Database window for the open database.

Do one of the following:
To import tables, on the File menu, point to Get External Data, and then click Import.
To link tables, on the File menu, point to Get External Data, and then click Link Tables.

In the Import (or Link) dialog box, in the Files of type box, make sure that Microsoft Access (*.mdb; *.adp; *.mda; *.mde; *.ade) is selected.

Click the arrow to the right of the Look in box, select the drive and folder where the Access file that you want to import or link is located, and then double-click the database's icon.

In the Import Objects (or Link Tables) dialog box, click each table that you want to import or link.



LINKED TABLES THAT HAVE MOVED
Use this procedure to view or to refresh links when the structure or location of a linked table has changed. The Linked Table Manager lists the paths to all currently linked tables.

1.Open the database that contains links to tables.
2.On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
3. Select the check box for the tables whose links you want to refresh.
4. Click OK to refresh the links.



I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer