Will table-Linking breaks after upload to website? Please help.

[JBLi]

Hi All,

My website is using 3 Access databases. I link the 1st database to
2 tables (1 in each) in the rest of the databases. For example:

DB 1 contains: Table1, -->Table2, -->Table4
DB 2 contains: Table2, Table 3
DB 3 contains: Table4, Table 5

That is, Database 1 has linked Table2 from DB2 and linked Table4
from DB3.

Assuming all the tables locally located in path: C:\Data\

Question: Will the links break if let say, upload them to my
website, which has physical path: c:\site\Data ?


What I am concern about is, will Access main relative path linking
or it only uses absolute path? Thanks for any information.



Regards,

JBLi

 

[chris]

It will break.
The links are stored as absolte paths.
Best create the identical path on your local machine, link
them there, then copy them.

 

[JBLi]

Thanks for the good suggestion. It will properly work as you suggested.

I have over 30 actual sites (sharing the same code base). Doing it manually
is not a easy task since each site locates in "different service-side path".
More suggestion needed.

- JB.

 

[John Vinson]

On Thu, 25 Mar 2004 02:05:35 -0500, "JBLi" <,,

I have over 30 actual sites (sharing the same code base). Doing it manually
is not a easy task since each site locates in "different service-side path".
More suggestion needed.

Get one of the many good "relinking" programs available. The one I use
is from the Access Developer's Handbook, but check out
http://www.mvps.org/access and search for "relinking".

 

[TC]

The alternative (and probably better) method is to run code at startup that
determines whether the links are broken, and if so, relinks the tables to
the database in the new location. This code could be written to assume, for
example, that all of the databases are in the same location. Then, the
following code gives the full pathname of the directory where the db's are:

dim sDir as string
sDir = dbengine(0)(0).name
while right$ (sdir, 1) <> "/"
sdir = left$ (sdir, len (sdir) - 1)
wend
msgbox sdir

HTH,
TC