link query from orther MDB file

[Souris]

Is it possible to link query from other MDB database?


I would like to retrieve data from other MDB, it seems I need links to the
table and have a local query to retrieve data.

It will be nice to link a query from other MDB instead of link the table.


Your information is great appreicated,

 

[Klatuu]

You can use external non linked data with queries, but the performance is
reduces.

As an example:

SELECT * FROM tlbOther IN "\\SomeServer\SomeFolder\AnotherDatabase.mdb";

 

[Douglas J. Steele]

Or

SELECT * FROM
[;Database=\\SomeServer\SomeFolder\AnotherDatabase.mdb].tlbOther

 

[Klatuu]

Merry Christmas, Doug.
--
Dave Hargis, Microsoft Access MVP

Or

SELECT * FROM
[;Database=\\SomeServer\SomeFolder\AnotherDatabase.mdb].tlbOther

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[Douglas J. Steele]

Same to you, Dave.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Merry Christmas, Doug.
--
Dave Hargis, Microsoft Access MVP

Or

SELECT * FROM
[;Database=\\SomeServer\SomeFolder\AnotherDatabase.mdb].tlbOther

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

You can use external non linked data with queries, but the performance
is
reduces.

As an example:

SELECT * FROM tlbOther IN
"\\SomeServer\SomeFolder\AnotherDatabase.mdb";

--
Dave Hargis, Microsoft Access MVP


:

Is it possible to link query from other MDB database?


I would like to retrieve data from other MDB, it seems I need links to
the
table and have a local query to retrieve data.

It will be nice to link a query from other MDB instead of link the
table.


Your information is great appreicated,