[AccessD] Transaction in MS-Access INFO REQUIRED

DJK(John) Robinson djkr at msn.com
Tue Mar 16 01:07:17 CST 2004


There's no transaction log in Access, so no concept of rolling back a
transaction after it has been committed.

Access transactions do provide atomicity, though, and multiple transactions
can be nested or overlapped.

HTH a little
John


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of S D
> Sent: 16 March 2004 06:42
> To: accessd
> Subject: [AccessD] Transaction in MS-Access INFO REQUIRED
> 
> 
> Hi group,
>  
> I need info regarding TRANSACTIONS in MS-Access 2000. 
> Specifically about the diffs between MS-Access 2000 and 
> SQL-Server/Oracle.
>  
> In Oracle / SQL-Server it is possible to roll-back a 
> transaction AFTER :
> - a system crash;
> - a network failure;
> - lost connection to the database;
> - etc.
>  
> So can anybody tell me/ point me to a good document where I 
> can read about the possibilities and disabilities of 
> MS-Access 2000 Transactions.
>  
> TIA 
>  
> Sander
> 
> Do you Yahoo!?
> Yahoo! Mail - More reliable, more storage, less spam
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



More information about the AccessD mailing list