Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MS Access - link to query in another Access database

How can I link query from another MS Access database? I know I can easily link tables, But I don't know how to link queries. The query takes data from many tables which I don't want to link.

like image 445
Tomas Avatar asked Jul 22 '13 11:07

Tomas


People also ask

How do I link two Access databases together?

Open the database, go to External Data tab in Import Group and select Access. The File Name text box will appear, type the source of database or Browse to see the File Open dialog box. Click on 'Link to the data source by creating a linked table' and press OK.

Can you export a query from one Access database to another?

You can export a table, query, form, report, macro, or module from one Access database to another. When you export an object, Access creates a copy of the object in the destination database.

Can you link to a query in Access?

You can link only to tables in another Access database. You cannot link to queries, forms, reports, macros, or modules.


1 Answers

You can do it this way:

SELECT [RemoteQueryname].* FROM [RemoteQueryname] IN 'C:\RemoteDatabase.mdb'

I have tested with databases locally on my machine and runs flawlessly. The only note I would like to point out is before running the query check to make sure the remote databse is closed or it will crash the one trying to do the query.

like image 67
ObieMD5 Avatar answered Nov 15 '22 20:11

ObieMD5