By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,850 Members | 972 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,850 IT Pros & Developers. It's quick & easy.

synchronize Access Database!!

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.