Jim Dettman
jimdettman at verizon.net
Mon Dec 5 08:30:26 CST 2011
Set the queries UseTransaction property to no in query design. Jim. -----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 10: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