471,612 Members | 2,203 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,612 software developers and data experts.

synchronize Access Database!!

Hi all.
I'm writting a multithreading program that will update a loacal Access
database.
I'm using OleDB connection to get access to the database from each
thread and my question is: how do I synchronize between threads\ how do
I lock the database so no clashes between threads occurs.
do I have to use a diffrent connection\adapters???

Jan 5 '06 #1
1 2589
For Access, I don't think that it's concurrency model is that good. At
best (from what I remember), it can handle 3-4 concurrent actions/users.

Because of this, what I would do is have ONE connection open to Access,
and lock on that single connection any time you want to perform an
operation. This way, you can insure that your operations will be
synchronized against the access file.

Note, that in database servers such as SQL Server, you don't have to
worry about it, the server worries about handling multiple connections.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

<ta*******@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
Hi all.
I'm writting a multithreading program that will update a loacal Access
database.
I'm using OleDB connection to get access to the database from each
thread and my question is: how do I synchronize between threads\ how do
I lock the database so no clashes between threads occurs.
do I have to use a diffrent connection\adapters???

Jan 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by taleran58 | last post: by
7 posts views Thread by Allison | last post: by
21 posts views Thread by nihad.nasim | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
1 post views Thread by ZEDKYRIE | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.