<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>...if records are being changed, transaction
processing is the only safe way to accomplish it since you need to be able to
safely back out of any changes made ...afaik transaction processing is supported
natively in Access only in Jet4/ADO apps and even then its pretty basic
functionality ...with DAO or A97, you either roll your own or switch to a SQL
Server be where transaction processing support is both rich and native
...having rolled my own Access transaction processing before, I can promise you
that its a pita ...HTH :)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>William Hindman<BR>"War is an ugly thing but not the ugliest of things; the
decayed and degraded state of moral and patriotic feelings which thinks that
nothing is worth war is much worse. A man who has nothing for which he is
willing to fight, nothing which is more important than his own personal safety,
is a miserable creature and has no chance of being free unless made and kept so
by the exertions of better men than himself." John Stuart Mill <BR></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=bchacc@san.rr.com href="mailto:bchacc@san.rr.com">Rocky Smolin -
Beach Access Software</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=AccessD@databaseadvisors.com
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, April 06, 2003 1:36
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Stop That Code!</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have some processes in an app which take a
while to execute. I generally put something on the screen to show the
user that progress is being made. I'd like to give them the capability to
abort the process by pressing the ESC key. Maybe they used data
selection criteria to select 12 records and instead selected 12,000. Or
made a mistake starting a long cost roll up or calculation which they'd like
to abort.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What's the simplest way to accomplish
this?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>