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

Give it a try Bill.  Although I didn't read anyone who actually had any success with that approach and the message.  It seems it must impact some users as MS have gone to the trouble of publishing that page.  You can turn off warnings at an application level, but I am not sure if that will be effective or not with the undo warning.

Cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
Sent: Monday, 5 December 2011 3:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Turn off delete buffer warning for Faster Delete Queries

Maybe the maxlocks will. For this I don't want code cuz I just wanted a quicker way to run a query in view just after editing.

Thanks.
On Dec 4, 2011 11:08 PM, "Darryl Collins" <darryl at whittleconsulting.com.au>
wrote:

> Hi Bill,
>
> It seems you get this message depending on how you do the delete.  How 
> are you deleting them?
>
> From what I understand if you can use
>
> CurrentDb.Execute("DELETE FROM tblMyTable"), dbfailonerror to execute 
> them without messages
>
> or
>
> if necessary (last resort) you can use
>
> With DoCmd
>        .SetWarnings False
>        .OpenQuery "QueryName"
>        .SetWarnings True
> End with
>
> It seems you can also get this if you hit MaxLocksPerFile as well << 
> http://support.microsoft.com/kb/286153>>
>
> Does any of that help?
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William (GE 
> Global Research, consultant)
> Sent: Monday, 5 December 2011 2: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