Monday, November 16, 2009

How can I view this linked table in Access?

I tried using Tools -%26gt; Database Utilities -%26gt; Linked Table Manager. However, I have a table linked to a network drive that is too long for me to see where it is using this method and there is no way, that I can tell, of scrolling to the right to see it.

How can I view this linked table in Access?
First get a TableDef object for the linked table in question. Then you can look at the connect and source table members to find out where it comes from. See the examples in the sources below.


No comments:

Post a Comment