Turn off 'Undo' buffer? Don't want messages.

[topmind]

For big queries, warning prompts pop up about "being too big to undo".
I don't care about the undo feature and wish to turn it off to both
speed up queries and avoid the annoying prompts. Is there a global
setting?

 

[Guest]

Look under Tools>Options>Edit/Find

You will find some options in the "Confirm" area of the window that allow
you do dismiss with confirmation warnings. Personally I have never run into
your error specifically, but I would suspect it could be avoided by
unchecking the "Action queries" option.

-Ted

 

[Guest]

Try setting the "Use Tranaction" property of the query to "Yes".

This behavior occurs in action queries that have to write a large amount of
data to a table. In this event, Access will create a temporary object to
store the data, and write it to the actual target table when the query is
done.

I'm not aware of any "global" setting that you can use to prevent this
behavior, but you CAN set the "Use Transaction" property of the query to
"Yes". When it's set that way, it will prompt you once to confirm that you
want to run the action query, and then if you hit "OK", it will write the
updates to the target table as it goes along.

If you want to prevent that initial confirmation message, set warnings off
before running the query.

HTH!

David

 

[Guest]

Whoops! Brainlock! Sorry about that.

I had it backwards. Try setting the Use Transaction property to NO.

For more info, see:

http://msdn.microsoft.com/library/d...ry/en-us/off2000/html/acproUseTransaction.asp

David