Labview causes my web page to hang when it's updating data from access database

[bloodxrage]

Hi,

I am working on labview(acquiring signal and inserting it to a database) and visual studio(webpage design) and i face this problem when the webpage is trying to update data from microsoft acess database.

Whenever i run the VI, the daq will acquire analog input from a circuit and pass the value into a database for the webpage to retrieve and update and show the latest data coming in on the webpage.But for some reason whenever i run the VI, the updating of data stopped at the webpage and only updates when i stopped the vi and whenever i try to refresh the page it will show a runtime error. I am wondering if it is possible to make the webpage update in real time instead of just updating it only when the vi is stopped and what causes the webpage to stop updating(labview side/webpage side).

I am using IIS to host the webpage and labview 8.6/database connectivity toolkit for the acquiring of data and storing it in access database.

[Dennis_Knutson · Accepted solution]

I believe this is a limitation with the Jet database. If I recall, Jet uses 'page' locking. This exact same thing happened to me on a larger scale with multiple testers. The solution was to use a more sophiticated database such as MySQL or SQL Server Express.

[bloodxrage]

thanks for the reply i will try the sql database instead of the access database and report on the progress

[bloodxrage]

Thanks for the help after using sql server i manage to update the data