link query from orther MDB file

  • Thread starter Thread starter Souris
  • Start date Start date
S

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,
 
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";
 
Or

SELECT * FROM
[;Database=\\SomeServer\SomeFolder\AnotherDatabase.mdb].tlbOther
 
Merry Christmas, Doug.
--
Dave Hargis, Microsoft Access MVP


Douglas J. Steele said:
Or

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

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)
Click to expand...
 
Same to you, Dave.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Klatuu said:
Merry Christmas, Doug.
--
Dave Hargis, Microsoft Access MVP


Douglas J. Steele said:
Or

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

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


Klatuu said:
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,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top