[AccessD] Stop That Code!

No transaction processing.  Mostly just report generation.  Cost roll-up and MRP calculations have no transactions either.

Rocky

  ----- Original Message ----- 
  From: William Hindman 
  To: accessd at databaseadvisors.com 
  Sent: Sunday, April 06, 2003 10:56 AM
  Subject: Re: [AccessD] Stop That Code!


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



------------------------------------------------------------------------------


  _______________________________________________
  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/2be2ee46/attachment-0001.html>