Re: tables from different databases but in single query

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: leon (svz_at_iprimus.com.au)
Date: 03/25/05 

Date: Fri, 25 Mar 2005 15:24:27 +0000

Because from what I understand, the links are specified in ABSOLUTE path
(i.e. i could not link to external tables with relative paths). the
whole point of my question was to provide RELATIVE addressing and
it would appear that the most "relative" or flexible way to specify a
database is via odbc managed entry - this way system admins can change
the location of databases to their hearts' content.

Graham R Seach wrote:
> Leon,
>
> Why not just link the tables from the external database(s)? Then you can
> refer to them directly.
>
> Regards,
> Graham R Seach
> Microsoft Access MVP
> Sydney, Australia
> ---------------------------
>
> "leon" <svz@iprimus.com.au> wrote in message
> news:424418cd$1@duster.adelaide.on.net...
>
>>Hi all,
>>i am aware of the following code to use single query in selecting from
>>multiple databases at once:
>>
>>SELECT PERSON.NAME DEPARTMENT.LOCATION
>>FROM
>>
>>PERSON IN 'C:\DB1.MDB',
>>DEPARTMENT IN 'C:\DB2.MDB'
>>
>>WHERE
>>
>>PERSON.DEPT = DEPARTMENT.ID
>>
>>my question is this:
>>
>>is it possible to NOT use absolute path when specifying the databases, but
>>rather relative paths - SPECIFICALLY if such databases are to be
>>configured via ODBC Data connection (DSN in control panel in windows).
>>
>>in other words, what i want is to specify the odbc configured name for
>>each of two databases rather than an absolute file path.
>>
>>Kind regards,
>>Leon.
>
>
>

Relevant Pages

  • Re: Call Perl Scripts from Other Dir in Linux, Path Messed Up
    ... You either specify an absolute path or your specify a relative path and ... the system sort-of prepends the current working directory. ... As for finding executables: add their absolute pathto the PATH ... or provide the absolute path of their location ...
    (comp.lang.perl.misc)
  • Re: Call Perl Scripts from Other Dir in Linux, Path Messed Up
    ... You either specify an absolute path or your specify a relative path and ... the system sort-of prepends the current working directory. ... As for finding executables: add their absolute pathto the PATH ... or provide the absolute path of their location ...
    (comp.os.linux.misc)
  • Re: Anyone ever setup a custom error page? Mine doesnt work if I specify it as a page
    ... CJM wrote on 08 jul 2004 in microsoft.public.inetserver.asp.general: ... >> File asks you to specify a file name (with the absolute path). ... >> don't understand what bugs you. ...
    (microsoft.public.inetserver.asp.general)
  • mysqldump no match issue
    ... I wanna do a ... mysqldump: No match. ... This happens either i put --all-databases or I specify any of the ... databases. ...
    (freebsd-questions)
  • Mysqldump password issue
    ... I wanna do a ... mysqldump: No match. ... This happens either i put --all-databases or I specify any of the ... databases. ...
    (freebsd-questions)