linking a query like a table

[Joerg Glissmann]

Hi there,

is there a way to link an Access XP database to a query in a different
database (Access XP as well) like you can do with tables?

My front ends need to operate on different data segments on one database
and I would like to get around modifying them..

Any help would be greatly appreciated.

--
Joerg Glissmann

remove pants to reply..

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the other db can make views - make the query a view and AccXP will
"see" it as a table and can, therefore, link to it.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6A2YoechKqOuFEgEQIL4gCg8G5bVOGxBDlcaH/WOGaxfIvL0v0An2wP
NteioZkH4PwXnMAw3Z545zmb
=oQBG
-----END PGP SIGNATURE-----

Joerg Glissmann wrote:

Hi there,

is there a way to link an Access XP database to a query in a different
database (Access XP as well) like you can do with tables?

My front ends need to operate on different data segments on one database
and I would like to get around modifying them..

Any help would be greatly appreciated.

[Joerg Glissmann]

Hi MG,

thanks for the reply, but you got me a bit dumbfounded here..
I thought queries in Access XP _were_ what other databases
call views.. (The data resides in an Access XP database as well)

Am I overlooking something here?

Thanks again,

Joerg
On Wed, 29 Oct 2003 21:51:23 GMT, MGFoster <[e-mail]> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the other db can make views - make the query a view and AccXP will
"see" it as a table and can, therefore, link to it.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6A2YoechKqOuFEgEQIL4gCg8G5bVOGxBDlcaH/WOGaxfIvL0v0An2wP
NteioZkH4PwXnMAw3Z545zmb
=oQBG
-----END PGP SIGNATURE-----

Joerg Glissmann wrote:

Hi there,

is there a way to link an Access XP database to a query in a different
database (Access XP as well) like you can do with tables?

My front ends need to operate on different data segments on one database
and I would like to get around modifying them..

Any help would be greatly appreciated.

--
Joerg Glissmann

remove pants to reply..

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Depends, if a query is a SELECT query, then, yes it can work as a
View. But, in Access, the term "query" also describes INSERT, UPDATE
and DELETE actions. All are referred to as queries.

Ah... I didn't see, in your 1st post, that you were trying to get data
from a query in another Access db. If both XP dbs are .mdb or .mde
files you can use the other query like this:

SELECT * FROM tblOtherTable In "c:\myDocs\OtherDB.mdb"

If the other db is an .adp file you can link to the "View" as if it
were a table (I believe - I don't do this much. I always use DAO pass
thru queries).

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6FczYechKqOuFEgEQIr+wCgqsSEgWy3YZm69pJgfa9+YN sZWrkAoKt6
pFk8J/l3VVBlhemBFJTmaI/X
=hsqO
-----END PGP SIGNATURE-----

Joerg Glissmann wrote:

Hi MG,

thanks for the reply, but you got me a bit dumbfounded here..
I thought queries in Access XP _were_ what other databases
call views.. (The data resides in an Access XP database as well)

Am I overlooking something here?

Thanks again,

Joerg
On Wed, 29 Oct 2003 21:51:23 GMT, MGFoster <[e-mail]> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If the other db can make views - make the query a view and AccXP will
"see" it as a table and can, therefore, link to it.

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6A2YoechKqOuFEgEQIL4gCg8G5bVOGxBDlcaH/WOGaxfIvL0v0An2wP
NteioZkH4PwXnMAw3Z545zmb
=oQBG
-----END PGP SIGNATURE-----

Joerg Glissmann wrote:

Hi there,

is there a way to link an Access XP database to a query in a
different database (Access XP as well) like you can do with tables?

My front ends need to operate on different data segments on one
database and I would like to get around modifying them..

Any help would be greatly appreciated.