[AccessD] Turn off delete buffer warning for FasterDelete Queries

I accept the warning. I am much more concerned that deleting records
from an open query or table has such an undo feature. Once I have pulled
the trigger on a delete query, I have already done my homework.

Really.

Famous last words.

Thanks again!

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Tuesday, December 06, 2011 3:00 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Turn off delete buffer warning for FasterDelete
Queries


  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

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