Linked Table manager window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning,

Just a simple little question (I hope!). When I use the Linked Table
Manager to view where my tables are pointed, I cannot see the entire path
because the listbox is restricted in size and there is nohorizontal scroll
bar?!

Is ther a way for me to see the entire path?

Thank you for the help,

Daniel P.
 
In Access 2003, Microsoft finally saw the light and added a horizontal
scrollbar. In earlier versions, you can ...

a) Open the linked table in design view, choose Properties from the View
menu and look at the 'Description' property.

b) In the Immediate window, type ...

? currentdb.TableDefs("tblTest").Connect

.... substituting the name of one of your linked tables for "tblTest".
 
Microsoft fixed this in Access 2003, but you're stuck if you have earlier
versions. You could write a little VB function to check the connection
property of the linked tables and display it on a custom form or a message
box.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Table Manager Errors 12
Can Built-in Access Forms Be Modified? 3
Seeing complete source location of linked tables 3
Question about Linked Tables 3
Linked Table Manager in ACCESS 4
Linked Table Manager does not list any tables in a DB. 1
Linked tables 1
linked table 3

Back
Top