synchronize Access Database!!

[taleran58]

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

 

[Nicholas Paldino [.NET/C# MVP]]

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.