用户是否可以使用向导意外创建删除查询？ [英] Can a user accidentally create a delete query using the wizard?

问题描述

我有一个用户使用查询向导在Access中创建查询。

现在她声称她的主表丢失了从查询中排除的所有数据都是
。你可以使用向导创建除选择

查询以外的任何内容吗？你觉得她的数据发生了什么？


我一直工作到星期五，所以我不能到她的办公室

并结账她做了什么。


你怎么看？


Kim

Hi,

I have a user that used the Query Wizard to create a query in Access.
Now she claims that her master table is missing all the data that was
excluded from the query. Can you create anything other than a select
query using the Wizard? What do you think happened to her data?

I am working remotely until Friday, so I can''t get down to her office
and check out what she did.

What do you think?

Kim

推荐答案

不确定为什么你必须询问是否可以使用向导创建删除查询

。选择一张桌子。单击插入|查询，您将看到

您可以使用向导创建的查询类型的完整列表。


也就是说，一旦用户进行设计查看查询，没有什么可以防止将某种查询更改为另一种查询，包括删除。


请记住，为了进入这个果酱，如果她自己做了，她就不得不读一条提示你即将删除xxx行......你是否

肯定你想这样做吗？并选择是。


使用户远离数据库窗口的良好理由。我有一个

例程，在我将MDE发布到

生产之前，我打电话来更改一些数据库属性。如何


调用MakePropertyChange（" allowbypasskey"，False）

调用MakePropertyChange（" AllowFullMenus"，False）

调用MakePropertyChange（" AllowBuiltInToolbars"，False）

调用MakePropertyChange（" StartUpShowDBWindow"，False）

调用MakePropertyChange（" StartUpShowStatusBar"，True）

调用MakePropertyChange（" AllowShortcutMenus"，True）

调用MakePropertyChange（" AllowToolbarChanges"，False）

调用MakePropertyChange（" AllowSpecialKeys"，False）


那个例程主要是这一行：


DB_o_m.Properties（rstrPropertyName）= rvarValue


其中DB_o_m设置为currentdb

Not sure why you have to ask whether or not you can create a delete query
with the wizard. Select a table. Click Insert | Query, and you''ll see the
whole list of query types you can create with the wizard.

That said, once the user is in design view of a query, there is nothing to
prevent changing one kind of query to another, including Delete.

Keep in mind that in order to get in this jam, if she did it to herself, she
had to read a prompt that says "You are about to delete xxx rows....Are you
sure you want to do this?" and select Yes.

Good argument for keeping users out of the database window. I have a
routine I call to change some database properties before I release my MDE to
production. How

Call MakePropertyChange("allowbypasskey", False)
Call MakePropertyChange("AllowFullMenus", False)
Call MakePropertyChange("AllowBuiltInToolbars", False)
Call MakePropertyChange("StartUpShowDBWindow", False)
Call MakePropertyChange("StartUpShowStatusBar", True)
Call MakePropertyChange("AllowShortcutMenus", True)
Call MakePropertyChange("AllowToolbarChanges", False)
Call MakePropertyChange("AllowSpecialKeys", False)

That routine is mainly this line:

DB_o_m.Properties(rstrPropertyName) = rvarValue

where DB_o_m is set to currentdb

我的意思是，如果用户刚进入并按照提示按

在数据库窗口中选择Query然后选择使用向导创建

查询，即可嘿创建一个删除查询，因为我没有
。 （这是她告诉我她采取的步骤。）


我听说你让最终用户摆弄数据库窗口;我们

不想让她甚至想让她使用Access来创建数据库，

但是它附带了Office软件包，有人在没有我们的情况下创建了它/>
知道;但是一旦出现问题。 。 。 。 。

Rick Wannall写道：

What I meant, If a user just went in and followed the prompts by
selecting Query in the database window and then selecting the "Create
Query using the wizard", could they create a delete query, because I
couldn''t. (This is the steps she told me she took.)

I hear you about having end users fiddling with the database window; we
didn''t want her to even want her to use Access to create the database,
but it comes with Office package, and somebody created it without us
knowing; but as soon as something goes wrong. . . . .
Rick Wannall wrote:

不知道为什么你必须询问是否可以使用向导创建删除查询
。选择一张桌子。单击插入|查询，你会看到你可以用向导创建的整个查询类型列表。

也就是说，一旦用户处于查询的设计视图中，就没有了
防止将一种查询更改为另一种查询，包括删除。

请记住，为了获得这个问题，如果她自己做了，她就有了阅读提示你即将删除xxx行....你是否确定要这样做？并选择是。

让用户远离数据库窗口的好参数。我有一个
例程，我在将MDE发布到生产之前调用了一些数据库属性。如何

调用MakePropertyChange（" allowbypasskey"，False）
调用MakePropertyChange（" AllowFullMenus"，False）
调用MakePropertyChange（" AllowBuiltInToolbars"，False）调用MakePropertyChange（" StartUpShowDBWindow"，False）
调用MakePropertyChange（" StartUpShowStatusBar"，True）
调用MakePropertyChange（" AllowShortcutMenus"，True）
调用MakePropertyChange（" AllowToolbarChanges" ，False）
调用MakePropertyChange（" AllowSpecialKeys"，False）

该例程主要是这一行：

DB_o_m.Properties（rstrPropertyName）= rvarValue

其中DB_o_m设置为currentdb

Not sure why you have to ask whether or not you can create a delete query
with the wizard. Select a table. Click Insert | Query, and you''ll see the
whole list of query types you can create with the wizard.

That said, once the user is in design view of a query, there is nothing to
prevent changing one kind of query to another, including Delete.

Keep in mind that in order to get in this jam, if she did it to herself, she
had to read a prompt that says "You are about to delete xxx rows....Are you
sure you want to do this?" and select Yes.

Good argument for keeping users out of the database window. I have a
routine I call to change some database properties before I release my MDE to
production. How

Call MakePropertyChange("allowbypasskey", False)
Call MakePropertyChange("AllowFullMenus", False)
Call MakePropertyChange("AllowBuiltInToolbars", False)
Call MakePropertyChange("StartUpShowDBWindow", False)
Call MakePropertyChange("StartUpShowStatusBar", True)
Call MakePropertyChange("AllowShortcutMenus", True)
Call MakePropertyChange("AllowToolbarChanges", False)
Call MakePropertyChange("AllowSpecialKeys", False)

That routine is mainly this line:

DB_o_m.Properties(rstrPropertyName) = rvarValue

where DB_o_m is set to currentdb

我肯定到现在你已经发现了只需按照

查询向导中的提示操作，就无法创建删除查询。


我怀疑这对你的si有帮助tuation。根据你的意愿，你不能只是走进来说，看，那不是你所做的。它不是可能的b $ b。你去了数据库窗口，创建了一个选择查询，把它改成了b $ b到删除查询，运行它，回答提示删除记录，并做了一个

大乱。


客户关系中的某个地方101我读到这不是一个好开口

开局。


RW


2006年5月31日下午7:55:20，福布斯写道：

I''m sure that by now you''ve found out that just by following prompts in the
query wizard you cannot create a delete query.

I doubt that that helps you with your situation. As much as you want to, you
can''t just walk in and say, "Look, that''s not what you did at all. It isn''t
possible. You went to the database window, created a select query, changed it
to a delete query, ran it, answered the prompt to delete records, and made a
big mess."

Somewhere in Customer Relations 101 I read that this is not a good opening
gambit.

RW

On 5/31/2006 7:55:20 PM, "forbes" wrote:

我的意思是，如果用户刚进入并按照提示选择数据库窗口中的查询，然后选择使用向导创建
查询 ;，他们可以创建一个删除查询，因为我无法做到。 （这是她告诉我她采取的步骤。）

我听说你让最终用户摆弄数据库窗口;我们不希望她甚至希望她使用Access来创建数据库，
但是它附带了Office软件包，有人在没有我们的情况下创建它
知道;但是一旦出现问题。 。 。 。 。

Rick Wannall写道：

What I meant, If a user just went in and followed the prompts by
selecting Query in the database window and then selecting the "Create
Query using the wizard", could they create a delete query, because I
couldn''t. (This is the steps she told me she took.)

I hear you about having end users fiddling with the database window; we
didn''t want her to even want her to use Access to create the database,
but it comes with Office package, and somebody created it without us
knowing; but as soon as something goes wrong. . . . .
Rick Wannall wrote:

不知道为什么你必须询问是否可以使用向导创建删除查询
。选择一张桌子。单击插入|查询，你会看到你可以用向导创建的整个查询类型列表。

也就是说，一旦用户处于查询的设计视图中，就没有了
防止将一种查询更改为另一种查询，包括删除。

请记住，为了获得这个问题，如果她自己做了，她就有了阅读提示你即将删除xxx行....你是否确定要这样做？并选择是。

让用户远离数据库窗口的好参数。我有一个
例程，我在将MDE发布到生产之前调用了一些数据库属性。如何

调用MakePropertyChange（" allowbypasskey"，False）
调用MakePropertyChange（" AllowFullMenus"，False）
调用MakePropertyChange（" AllowBuiltInToolbars"，False）调用MakePropertyChange（" StartUpShowDBWindow"，False）
调用MakePropertyChange（" StartUpShowStatusBar"，True）
调用MakePropertyChange（" AllowShortcutMenus"，True）
调用MakePropertyChange（" AllowToolbarChanges" ，False）
调用MakePropertyChange（" AllowSpecialKeys"，False）

该例程主要是这一行：

DB_o_m.Properties（rstrPropertyName）= rvarValue

其中DB_o_m设置为currentdb

Not sure why you have to ask whether or not you can create a delete query
with the wizard. Select a table. Click Insert | Query, and you''ll see the
whole list of query types you can create with the wizard.

That said, once the user is in design view of a query, there is nothing to
prevent changing one kind of query to another, including Delete.

Keep in mind that in order to get in this jam, if she did it to herself, she
had to read a prompt that says "You are about to delete xxx rows....Are you
sure you want to do this?" and select Yes.

Good argument for keeping users out of the database window. I have a
routine I call to change some database properties before I release my MDE to
production. How

Call MakePropertyChange("allowbypasskey", False)
Call MakePropertyChange("AllowFullMenus", False)
Call MakePropertyChange("AllowBuiltInToolbars", False)
Call MakePropertyChange("StartUpShowDBWindow", False)
Call MakePropertyChange("StartUpShowStatusBar", True)
Call MakePropertyChange("AllowShortcutMenus", True)
Call MakePropertyChange("AllowToolbarChanges", False)
Call MakePropertyChange("AllowSpecialKeys", False)

That routine is mainly this line:

DB_o_m.Properties(rstrPropertyName) = rvarValue

where DB_o_m is set to currentdb

-

科学组织常见意识到许多美丽的理论被一个丑陋的事实所杀（Thomas Huxley）。

--
Science is organized common sense where many a beautiful theory is killed by an ugly fact (Thomas Huxley).

这篇关于用户是否可以使用向导意外创建删除查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！