|
| 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
October 20th, 2004, 04:26 PM
|
|||
|
|||
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
October 20th, 2004, 06:31 PM
|
|||
|
|||
|
"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
October 20th, 2004, 07:59 PM
|
|||
|
|||
|
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
October 20th, 2004, 10:52 PM
|
|||
|
|||
|
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
October 21st, 2004, 10:20 PM
|
|||
|
|||
|
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 | |
Linear Mode
