[AccessD] Stop That Code!

Hi Charlotte

Not that I know of. I used them a lot.
But you may be right.
Some features were added later, though, like flush cache.

/gustav


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