Error occur when multiple users access database

[KitChongYue]

Hi all,

I am using Microsoft access to create my database and using LabVIEW to read/write information from/to it.

Problem occur when:

Multiple user acess database at the same time.

OR

one is acessing database, while another user trying to open connection with it at the same time.

How can I solve this problem???

I need the answer urgently.

Thank you so much for your help...

[KitChongYue]

Anyone one can help me with that ???

I need the answer urgently...

Thank you very much...

[Dennis_Knutson]

As I mentioned in this very recent post (did you not do a search), I think the best approach is to get rid of the jet database and move to something that better supports multi-users.

[KateB]

If you don't want to change database, the only hope is to check for this error, and loop to open database connection until the error disappear.

[KitChongYue]

I have tried the method u mentioned, but it can't work.

It's true that the error would dissapear after some time and the same error would appear when LabVIEW try to open connection with it again although no other user is accessing database at the time.

This cause my program to hang.

[KateB]

Then, change the database.

MySQL is the best choice in term of cost.

[Dennis_Knutson]

SQL Server Express is also free.