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 everyone,
I have a database with some linked tbales in it, but I need to find out where the original tables are located that these are linked to. If i right click the table and go to properties it doesn't tell me. Is there a way to find this out without searching through lots of databases on differant network drives? Thanks |
#2
|
|||
|
|||
Linked Tables
Check the Linked Tables Manager after you right-click.
-- Marin Kostov Microsoft Office XP Master Instructor |
#3
|
|||
|
|||
Linked Tables
Or:
IN the immediate window (CTRL-G), ?Currentdb.TableDefs("TableName").Connect Chris Nebinger -----Original Message----- Hi everyone, I have a database with some linked tbales in it, but I need to find out where the original tables are located that these are linked to. If i right click the table and go to properties it doesn't tell me. Is there a way to find this out without searching through lots of databases on differant network drives? Thanks . |
#4
|
|||
|
|||
Linked Tables
A third method is to hoover the mouse over the linked Table. After a short
while, the Coonection String will be display as a tip with yellow background. -- HTH Van T. Dinh MVP (Access) "Daniel" wrote in message ... Hi everyone, I have a database with some linked tbales in it, but I need to find out where the original tables are located that these are linked to. If i right click the table and go to properties it doesn't tell me. Is there a way to find this out without searching through lots of databases on differant network drives? Thanks |
#5
|
|||
|
|||
Linked tables
You can do it in a different way. Instead of keeping the database on the "My Documents" directory, create a directory on the C: drive(say MyProject) and keep the files in this folder. The reason is the there is a mismatch in the directory structure - Frank to Susan.
I hope this helps. vb "Frank" wrote: In Access 2000 . . . I would like to be able to link a table in the same folder and make it always work whereever I put as long as the app and tables are in the same folder. In other words, an Access file in my folder C:\Documents and Settings\Frank\My Documents links a table from a file in the same folder. I'd like to email both files to another user, let her save them to her folder, C:\Documents and Settings\Susan\My Documents and have it just work because their both still in the same folder. Seems simple enough, but Access seems to want the full path every time. |
#6
|
|||
|
|||
Linked tables
How about simply importing the table into the database and eliminating the
need for linking to an outside file? "Frank" ¦b¶l¥ó om ¤¤¼¶¼g... In Access 2000 . . . I would like to be able to link a table in the same folder and make it always work whereever I put as long as the app and tables are in the same folder. In other words, an Access file in my folder C:\Documents and Settings\Frank\My Documents links a table from a file in the same folder. I'd like to email both files to another user, let her save them to her folder, C:\Documents and Settings\Susan\My Documents and have it just work because their both still in the same folder. Seems simple enough, but Access seems to want the full path every time. |
#7
|
|||
|
|||
Linked tables
On 13 Jul 2004 05:42:16 -0700, (Frank) wrote:
I just don't want to dictate how users structure their hard drives. It seems so basic to be able to tell it to check the current directory it's hard to believe it's not an option. Oh well. It's an option, but one you will need to program in VBA. Check out the code at http://www.mvps.org/access/tables/tbl0009.htm This could be adapted to search the current directory for the backend database. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#8
|
|||
|
|||
Frank wrote on 13/7/2004 1:42 pm:
I just don't want to dictate how users structure their hard drives. It seems so basic to be able to tell it to check the current directory it's hard to believe it's not an option. Oh well. Thanks for the reply. "vb" wrote in message ... You can do it in a different way. Instead of keeping the database on the "My Documents" directory, create a directory on the C: drive(say MyProject) and keep the files in this folder. The reason is the there is a mismatch in the directory structure - Frank to Susan. I hope this helps. vb I have a similar problem, sending Access 2000 & linked Excel files to various people in different parts of the country, they need to be linked, as it is the Excel file that gets edited, not everyone has Access. File, Get External Data, Link Tables? Or Tools, Database Utilities, Linked Table Manager? Tools, Options, General, Default database folder? But change it back again afterwards. HTH, &B-) Ian No Spam, Please reply to newsgroup! |
#9
|
|||
|
|||
Frank wrote on 13/7/2004 1:42 pm:
I just don't want to dictate how users structure their hard drives. It seems so basic to be able to tell it to check the current directory it's hard to believe it's not an option. Oh well. Thanks for the reply. Extract from the help file; Important If you link to a file on a local area network, make sure that you use a universal naming convention (UNC) path, instead of relying on the drive letter of a mapped network drive in Windows Explorer. A drive letter can vary on a computer, or it may not always be defined; whereas, a UNC path is a reliable and consistent way for Microsoft Access to locate the data source that contains the linked table. Any the wiser? Have a look for UNC in help. HTH, &B-) Ian No Spam, Please reply to newsgroup! |
Thread Tools | |
Display Modes | |
|
|