William Hindman
wdhindman at bellsouth.net
Sun Apr 6 12:56:08 CDT 2003
...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 :) William Hindman "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 ----- Original Message ----- From: Rocky Smolin - Beach Access Software To: AccessD at databaseadvisors.com Sent: Sunday, April 06, 2003 1:36 PM Subject: [AccessD] Stop That Code! Dear List: 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. What's the simplest way to accomplish this? MTIA, Rocky Smolin Beach Access Software ------------------------------------------------------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030406/f94bd203/attachment-0001.html>