How does Access database handle concurrent updates?

[Perdit]

When a number of calls are made to update (add records, update field)
at the same time what does MS Access do to handle the calls?

Does Mysql with php handle similar calls better??

Thanks

[Brynn]

I think MySQL with any script would handle it better ... in this case,
I don' t think you have to worry quite as much about the scripting
language, but be worried about the performance of the database. MySQL
is a pretty nice DB made to handle wuite a bit more than Access
(although I still prefer MS SQL)

On 11 Jan 2004 06:26:33 -0800, [email]cftranslate@hotpop.com[/email] (Perdit) wrote:

>When a number of calls are made to update (add records, update field)
>at the same time what does MS Access do to handle the calls?
>
>Does Mysql with php handle similar calls better??
>
>Thanks

[Bob Barrows]

Perdit wrote:

> When a number of calls are made to update (add records, update field)
> at the same time what does MS Access do to handle the calls?

Pretty much the same thing most rdbms's do: it encapsulates them in
transactions and applies appropriate locks to the tables involved to make
sure none of them step on each other until each transaction is committed.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"