Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
linked tables

ResolvedVersion 2007

Lorena has attended:
Access Advanced course
Access VBA course

Linked Tables

Hi,
I have some tables linked to another data base and I need to know how to modify that path to link the tables to a different data base.
Thank you!!
Lorena


RE: Linked Tables

Hi Lorena

To modify a link to a table in another database you can right click and choose Delete.

Notice the prompt says this will only remove the link and not delete the table!

Then to link to another table or database select
External Data, Access (in Import group)
Choose Link to a data source by creating a linked table
Click the Browse button and select the location of the database, OK.
Then select the Table to link to and press Ok.

The linked table will now appear with a small blue arrow at the top left of the table icon.

There is also an option called Linked Table Manager when you right click the icon. This allows you to refresh a link but unfortunately not actually change it.

Please let me know if this helps and answers your question about changing link locations.

Regards
Doug Dunn
Best STL

RE: Linked Tables

Thanks a lot Doug, question answered.

Access tip:

Insert The Current Date

To insert the current date into a Table field or Form Text box use:

Ctrl+Semi-Colon(;)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.