Access 2007坚持保存查询 [英] Access 2007 inists on saving queries

问题描述

最让人烦恼的是，但我在Google中找不到有关它的任何信息.

More of an annoyance than anything else, but I couldn't find any information on it in Google.

我经常会在Access 2007中创建一个查询来测试某些内容，或者一次快速地获取一些结果.我不想保存这些查询，因为它们仅对一种用途有用.

I'll often create a query in Access 2007 to test something, or quickly grab some results on a one time basis. I don't want to save these queries, as they're only good for one use.

但并非总是如此，但经常，Access不会在不保存该查询的情况下关闭该查询，这意味着我以后必须删除它.这样可以防止我在保存Access之前关闭Access，并造成大量不必要的查询.

Not always, but often, Access won't close this query without me saving it, which then means I have to later delete it. This can prevent me from closing Access until I've saved it, and creates a derth of unwanted queries.

为什么会这样?有什么特别的东西可以引爆它吗?

Why is this happening? Is there something in particular that sets it off?

推荐答案

Track name AutoCorrect info路径对我来说不是什么.相反，事实证明我没有设置DoCmd.SetWarnings False.进入立即窗口并运行DoCmd.SetWarnings True会带回旧的您要保存此查询是/否/取消"窗口.

The Track name AutoCorrect info path was not what did it for me. Rather it turns out I had left DoCmd.SetWarnings False set. Going into the immediate window and running DoCmd.SetWarnings True brought back the old "Do you want to save this query Yes/No/Cancel" window.

这篇关于Access 2007坚持保存查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！