Linked tables

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

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?
 
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.
 
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.
Click to expand...

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.
 
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.
Click to expand...
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.
Click to expand...

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.
Click to expand...
Any the wiser? Have a look for UNC in help.

HTH, &B-) Ian
No Spam, Please reply to newsgroup!
 
Back
Top