[AccessD] Turn off delete buffer warning for Faster Delete Queries

Rocky Smolin rockysmolin at bchacc.com
Sun Dec 4 22:04:37 CST 2011


I suppose it's there in case you mistakenly start to delete all records in a
table or mean to delete 100 and delete 10,000 instead.  The only way I know
is DoCmd.SetWarnings False but that's in code.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William
(GE Global Research, consultant)
Sent: Sunday, December 04, 2011 7:25 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Turn off delete buffer warning for Faster Delete Queries

Is there a way to turn warnings off through the interface and back again,
without using a macro that has such steps or calling a VBA routine? Or is
there a way to get rid of that message that interrupts query execution to
inform me about exceeding Access's rollback buffer, thus continuing without
undo. I understand why Access offers this but frankly for me it is
superfluous, I would never change my behavior regarding that message other
than to click ok, so the warning is useless and an annoyance to me
personally.

TIA.



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list