Menu
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.
445
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.
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.
You can link only to tables in another Access database. You cannot link to queries, forms, reports, macros, or modules.
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.
67
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
