[AccessD] Stop That Code!

Mark Whittinghill mwhittinghill at symphonyinfo.com
Mon Apr 7 14:47:14 CDT 2003


You can do transactions in A97 and DAO.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
  ----- Original Message ----- 
  From: William Hindman 
  To: accessd at databaseadvisors.com 
  Sent: Sunday, April 06, 2003 11: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 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030407/dd803f6a/attachment-0001.html>


More information about the AccessD mailing list