[AccessD] Transaction in MS-Access INFO REQUIRED

Sander/John,

  Actually, to be a little more specific, there is no rollback/forward
capability with JET as the database engine, but if you use Access with MSDE
or SQL Server, then you pick that up.

Jim Dettman
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DJK(John)
Robinson
Sent: Tuesday, March 16, 2004 2:07 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Transaction in MS-Access INFO REQUIRED


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
>
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com