dbTalk Databases Forums  

ACID test for Microsoft Access databases?

comp.database comp.database


Discuss ACID test for Microsoft Access databases? in the comp.database forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David
 
Posts: n/a

Default ACID test for Microsoft Access databases? - 09-15-2003 , 09:19 PM






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

Reply With Quote
  #2  
Old   
Neb Revod
 
Posts: n/a

Default Re: ACID test for Microsoft Access databases? - 09-16-2003 , 01:09 AM






In article <Xns93F7E3406F34Fslavboysympaticoca (AT) 206 (DOT) 172.150.13>,
slav_boy (AT) hotmail (DOT) com says...
Quote:
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.
Oh, man.
Here we go again...


Reply With Quote
  #3  
Old   
David
 
Posts: n/a

Default Re: ACID test for Microsoft Access databases? - 09-16-2003 , 09:40 AM



Neb Revod <spammers.biteme (AT) flatline (DOT) com> wrote in
news:MPG.19d048d2e166103498978a (AT) pdx (DOT) news.speakeasy.net:

Quote:
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?


Reply With Quote
  #4  
Old   
Neb Revod
 
Posts: n/a

Default Re: ACID test for Microsoft Access databases? - 09-16-2003 , 12:19 PM



In article <Xns93F86CD18F4E8slavboysympaticoca (AT) 207 (DOT) 35.177.134>,
slav_boy (AT) hotmail (DOT) com says...
Quote:
Neb Revod <spammers.biteme (AT) flatline (DOT) com> wrote in
news:MPG.19d048d2e166103498978a (AT) pdx (DOT) news.speakeasy.net:

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.


Reply With Quote
  #5  
Old   
David
 
Posts: n/a

Default Re: ACID test for Microsoft Access databases? - 09-17-2003 , 12:52 AM



Neb Revod <spammers.biteme (AT) flatline (DOT) com> wrote in
news:MPG.19d0e5f24f59186298978c (AT) pdx (DOT) news.speakeasy.net:

Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.