By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,583 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

linking a query like a table

P: n/a

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..
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
-----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.


Nov 12 '05 #2

P: n/a

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 <me@privacy.com> 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..
Nov 12 '05 #3

P: n/a
-----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 <me@privacy.com> 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.




Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.