ACID Compliance

[Emma]

Is Access ACID Compliant?

Thanks
Emma

 

[Tony Toews]

Is Access ACID Compliant?

What is ACID Compliant? Ahh, I see something at
http://www.fredosaurus.com/notes-db/transactions/acid.html

There are transactions with Commit and Rollback so I suspect 1-3 would
be ok. With the exception of doing forms/subforms entry in that the
main form record is saved to the database when the subform entries
aren't saved. But you could work around that with temporary tables.
I think someone once posted another technique but I don't recall any
details.

As far as #4 goes no.

Of course Access can work with SQL Server, Oracle and others so that
it can be quite robust.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[david epsom dot com dot au]

Is Access ACID Compliant?

No.

Queries run through the Access User Interface are run
as individual transactions, so unless you specifically
turn off transactional handling (as you can when running
a macro action), they are (sort of) ACI (see below).
Durability can be considered to depend on you flushing
the result to disk, which Windows otherwise handles as
a background task.

Jet/ADO/DAO actions are only ACID if they are run inside
transactions. Atomic compliance for single SQL statements
(a basic ANSI compatibility requirement) was turned off
for Jet 3.5 & Jet 4.0: You can only make Jet SQL Atomic
by running inside a transaction.

Jet Transactions are broken. When you run out of locks,
you are supposed to get a 'partial commit', which you
cannot then roll back. I've never seen that happen (for
me, the transaction has always failed), but it's in the
documentation.

Since simple SQL actions are not Atomic, and Transactions
are not Atomic, Access/Jet actions are not ACID.

Access actions were supposed to be ACID in Access 2.0, 1994:
the current situation is just the result of the never ending
process of 'improvement' of the Access platform since then.

(david)

 

[Albert D. Kallal]

If you use a adp project, the I would have to think yes....

The desktop MSDE and adp projects (native sql server access) have been
included with last 3 versions of ms-access.

So, for the last 3 versions....I would have to say yes....

 

[david epsom dot com dot au]

I see now that you have yes,no and a maybe answer, so just
to correct my contribution: Access actions are not formally
ACID when used with data in a Jet MDB. Are presumably ACID
when used in the newer form designed to support that: ADP
project.

(david)