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

Check the Linked Tables Manager after you right-click.

--
Marin Kostov
Microsoft Office XP Master Instructor

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
.

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

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.

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.

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

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!

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!