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

Link to an ACCESS query in another ACCESS database

P: 3
Hi Experts,
I have some Oracle views linked in an Access database this is the good part. Now I try to link to an Access query from other database (still Access) but I have no clue how.
I'm a bit frustrated since I can have a link to Oracle views but not to an ACCESS query. I try to make an ACCESS page succes, but when I try to link to that html file => no data but scrap.
So please somebody have an ideea ?
Thanks,
Sorin
Sep 13 '06 #1

✓ answered by atherstone

Actually, you can create an SQL query with the following info and it will act as a remote query.
Expand|Select|Wrap|Line Numbers
  1. SELECT [RemoteQueryname].* FROM [RemoteQueryname] IN 'C:\RemoteDatabase.mdb'

Share this Question
Share on Google+
5 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,
In Access you can link only to an Access table and not to entire query!

But you can import your query concerning your linked tables! So the query is executed from the respective database!

Have a nice day!

:)
Sep 13 '06 #2

P: 3
Thanks a lot. This is what I was afraid.
Thinking to a solution I made a html Access page and I dropped in a folder.
When I open that file is populated with query data, is OK.
Now sice I can linke as a table to a html file, why is not possible to link via this html file?
Sep 13 '06 #3

P: 4
Actually, you can create an SQL query with the following info and it will act as a remote query.
Expand|Select|Wrap|Line Numbers
  1. SELECT [RemoteQueryname].* FROM [RemoteQueryname] IN 'C:\RemoteDatabase.mdb'
Feb 1 '13 #4

zmbd
Expert Mod 5K+
P: 5,397
That's slick!
I can see how this could be used in another application or two!
Feb 2 '13 #5

NeoPa
Expert Mod 15k+
P: 31,434
This goes for TableDefs too, in case that isn't clear. Linked tables aren't always necessary (though they can be very handy of course).
Feb 4 '13 #6

Post your reply

Sign in to post your reply or Sign up for a free account.