| | |
|
|
|
ACID Compliance |
|---|
| message from Emma on 1 Jun 2004 |
Is Access ACID Compliant?
Thanks
Emma
|
| Tony Toews replied to Emma on 01 Jun 2004 |
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
|
| david epsom dot com dot au replied to Emma on 2 Jun 2004 |
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)
"Emma" <anonymous@discussions.microsoft.com> wrote in message
news:16e5501c44849$14a11510$a101280a@phx.gbl...
|
| david epsom dot com dot au replied to david epsom dot com dot au on 2 Jun 2004 |
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)
"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:etbM1DFSEHA.2936@TK2MSFTNGP12.phx.gbl...
|
| Albert D. Kallal replied to Emma on 2 Jun 2004 |
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....
|
|
Archived message: ACID Compliance (MS Access)
