[AccessD] Stop That Code!

But I seem to recall that Access 2.0 transactions had some limitations
that disappeared in later versions.

Charlotte Foust

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Tuesday, April 08, 2003 4:48 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Stop That Code!


Hi William and Mark

Actually from Access 2.0 and forward ...

/gustav


> You can do transactions in A97 and DAO.

> Mark Whittinghill

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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com