Jim Dettman
jimdettman at verizon.net
Tue Dec 6 14:00:06 CST 2011
Understand that your not turning off the warning, but setting the query so transactions are not used. That means you'll never run out of locks nor will you get the message that the transaction cannot be undone past a certain point. Only do this if you don't care if a failure occurs in the middle execution and can simply re-run it if that happens. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson Sent: Tuesday, December 06, 2011 02:07 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Turn off delete buffer warning for Faster Delete Queries Can't wait to try this (but I have to because I am not near PC)... sounds promising. On Dec 5, 2011 9:31 AM, "Jim Dettman" <jimdettman at verizon.net> wrote: > > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com