MS Access-链接到另一个Access数据库中的查询 [英] MS Access - link to query in another Access database

问题描述

如何链接来自另一个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.

这篇关于MS Access-链接到另一个Access数据库中的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！