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

Darryl Collins darryl at whittleconsulting.com.au
Sun Dec 4 22:05:29 CST 2011


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






More information about the AccessD mailing list