如何查询查询是否与数据库中的其他数据相关？ [英] How can I find out if a query is related to other data in my database?

问题描述

Der社区


我有一个包含多种表格，表格，查询和报告的数据库。我实际上正在编辑数据库，并希望删除一些查询。在我删除查询之前，我想知道这个查询是否与数据库中的另一个数据（表单，报表）相关，以便不删除相关查询。


有人可以告诉我怎么以及如果我能快速找到它？


非常感谢


Mike

解决方案

首先，我建议无论何时创建新对象（尤其是查询），您都可以右键单击Nave窗格中的查询，然后在查看属性下输入查询的内容。

或者在设计视图中使用查询，如果您在灰色区域中单击鼠标左键，则会获得查询属性，您可以输入描述。 （记得在输入说明后按回车键，否则不会被保存）。


无论如何，这是为了将来。


我有一个相当错误的程序会有所帮助，但会看看我是否可以解决问题，然后再发送。


Phil

1. 我使用的方法是生成有关特定查询或所有查询的依赖关系信息。在本演示中，我使用Northwind示例数据库的订单详细信息扩展查询。
2. 基本代码：
   

   展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

1. 以下是我想提及的另外两点：
   1. 我给你的示例显示了Query 依赖的对象。
   2. 为了显示依赖于Query的对象，你必须使用 Dependents ， NOT Dependencies ，AccessObjec的属性t对象。

2. 希望这会有所帮助。
3. 我确实意识到这有点令人困惑（LOL）。

Der Community

I have a database with several forms, tables, queries and reports. I am actually editing the database and would like to delete some of the queries. Before I delete a query I would like to know if this query is related to another data (form, report) in the database in order not to delete a related query.

Can somebody tell me how and if I can quickly find this out?

Thanks a lot

Mike

解决方案

Firstly, I suggest that whenever you create a new object (and particularly a query) you either right click on the query in the Nave Pane, and under View Properties, enter what the query is for.
Alternatively with the query in design view, if you left click in the grey area, you get the query properties and you can enter the Description. (Remember to press the return key after you have entered the description, else it won''t be saved).

Anyway, that''s for the future.

I have a rather buggy program that will help, but will see if I can sort out the problems, and send it later.

Phil

1. The Method that I use is to generate Dependency Information regarding a specific Query, or all Queries. In this Demo I use the Order Details Extended Query of the Northwind Sample Datbase.
2. Base Code:
   

   Expand|Select|Wrap|Line Numbers

1. Here are two additional points that I wish to mention:
   1. The Example that I gave you displays the Object(s) that the Query depends on.
   2. In order to display the Object(s) that depend on the Query, you must use the Dependants, NOT Dependencies, Property of the AccessObject Object.

2. Hope this helps.
3. I do realize that this is a little confusing (LOL).

这篇关于如何查询查询是否与数据库中的其他数据相关？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！