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

Dan Waters df.waters at comcast.net
Thu Dec 1 22:34:11 CST 2011


No Messages --> CurrentDb.Execute("DELETE FROM tblMyTable"), dbfailonerror

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Sunday, December 04, 2011 10:05 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Turn off delete buffer warning for Faster Delete
Queries

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




More information about the AccessD mailing list