Re: Will table-Linking breaks after upload to website? Please help.
From: TC (no_at_email.here)
Date: 03/26/04
- Next message: John Vinson: "Re: possible to combine databases?"
- Previous message: John Vinson: "Re: linking tables in separate databases"
- In reply to: chris: "Will table-Linking breaks after upload to website? Please help."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 26 Mar 2004 10:52:56 +1030
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
"chris" <anonymous@discussions.microsoft.com> wrote in message
news:12fc101c41226$45122210$a301280a@phx.gbl...
> 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.
>
> >-----Original Message-----
> >
> >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
> >
> >
> >.
> >
- Next message: John Vinson: "Re: possible to combine databases?"
- Previous message: John Vinson: "Re: linking tables in separate databases"
- In reply to: chris: "Will table-Linking breaks after upload to website? Please help."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
