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

William Benson vbacreations at gmail.com
Tue Dec 6 13:06:44 CST 2011


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
>



More information about the AccessD mailing list