[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
>