ACID test for Microsoft Access databases?

[David]

I suspect I already know the answer to this one, but I wanted to get the
scoop from the pros:

Do Microsoft Acccess databases pass the ACID test? The test case is where
an Access database resides on a shared drive and multiple users can
simultaneously modify the database.

David

[Neb Revod]

Post by David
I suspect I already know the answer to this one, but I wanted to get the
Do Microsoft Acccess databases pass the ACID test? The test case is where
an Access database resides on a shared drive and multiple users can
simultaneously modify the database.

Oh, man.
Here we go again...

[David]

Post by Neb Revod

Post by David
Do Microsoft Acccess databases pass the ACID test? The test case is
where an Access database resides on a shared drive and multiple users
can simultaneously modify the database.

Oh, man.
Here we go again...

Since I'm new to this newsgroup, I'm not trying to do anything "again". If
this was the subject of some tools wars back in the past, I'm sorry, but I
really need to know the answer to this question.

Perhaps you can suggest another newsgroup where I should ask it?

[Neb Revod]

Post by David

Post by Neb Revod

Post by David
Do Microsoft Acccess databases pass the ACID test? The test case is
where an Access database resides on a shared drive and multiple users
can simultaneously modify the database.

Oh, man.
Here we go again...

Since I'm new to this newsgroup, I'm not trying to do anything "again". If
this was the subject of some tools wars back in the past, I'm sorry, but I
really need to know the answer to this question.
Perhaps you can suggest another newsgroup where I should ask it?

No, no. Didn't mean to offend. This is NG is about as good a place as
any to ask that question. Its just that your question comes right on the
heels of a three-week rant-fest about whether or not Access is a
"relational" database, or whether it is a database at all.

Strictly speaking, the answer is no. While an Access database can be
configured to provide functionality that will satisfy the first three
requirements, it is notorious for its inability to provide for the
"durability" requirement.

[David]

Post by Neb Revod
Strictly speaking, the answer is no. While an Access database can be
configured to provide functionality that will satisfy the first three
requirements, it is notorious for its inability to provide for the
"durability" requirement.

Ah, I got on the tail end of a tool holy war. OK. Thanks for the response,
it's pretty well what I expected. Too bad not everyone can afford Oracle
and the hardware to run it.

David