MS Access-链接到另一个Access数据库中的查询
问题描述：
如何链接来自另一个MS Access数据库的查询?我知道我可以
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.
答
您可以这样做:
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.