linked tables

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

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linked Tables

Linked Tables

resolvedResolved · High Priority · Version 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 articles

Please browse our web site to find out more about
microsoft access courses in london and other training courses.

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.07 secs.