If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linked Tables
Hi
Access 2000 Is there a way to find out the location of the source table from a database's linked tables? Thanks in advance PJ |
#2
|
|||
|
|||
"PJ Usher" wrote in news:uZ4zikrtEHA.2116
@TK2MSFTNGP14.phx.gbl: Is there a way to find out the location of the source table from a database's linked tables? Open the VBA editor, find the immediate window and enter the following: debug.print Tabledefs("MyTable").Connect HTH Tim F |
#3
|
|||
|
|||
Hi Tim
I get a compile error: Sub or function not defined Sorry PJ "Tim Ferguson" wrote in message ... "PJ Usher" wrote in news:uZ4zikrtEHA.2116 @TK2MSFTNGP14.phx.gbl: Is there a way to find out the location of the source table from a database's linked tables? Open the VBA editor, find the immediate window and enter the following: debug.print Tabledefs("MyTable").Connect HTH Tim F |
#4
|
|||
|
|||
On Wed, 20 Oct 2004 14:59:35 -0400, "PJ Usher"
wrote: Hi Tim I get a compile error: Sub or function not defined Sorry PJ "Tim Ferguson" wrote in message 6... "PJ Usher" wrote in news:uZ4zikrtEHA.2116 @TK2MSFTNGP14.phx.gbl: Is there a way to find out the location of the source table from a database's linked tables? Open the VBA editor, find the immediate window and enter the following: debug.print Tabledefs("MyTable").Connect I'm sure Tim meant to say Debug.print CurrentDb.Tabledefs("MyTable").Connect John W. Vinson[MVP] Join the online Access Chats Tuesday 11am EDT - Thursday 3:30pm EDT http://community.compuserve.com/msdevapps |
#5
|
|||
|
|||
John Vinson wrote in
: debug.print Tabledefs("MyTable").Connect I'm sure Tim meant to say Debug.print CurrentDb.Tabledefs("MyTable").Connect Thanks John... Tim F |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No tables in Linked Table Manager (Access2003) | DP | New Users | 3 | August 6th, 2004 09:46 PM |
Linked Tables Manager | Ryan | Database Design | 3 | June 16th, 2004 09:27 PM |
Linked text boxes containing tables | Gary McGill | Page Layout | 3 | June 9th, 2004 11:57 PM |
adding records to linked tables | New Users | 6 | April 27th, 2004 03:24 AM |