MS Access Database connectivity simultaneous (DSN) doubt

[Grugh_Mike]

I am using MS Access database with DSN for data inserting and reading using labview database connectivity toolkit.

I use the insert into command using one DSN (connected to the same database) at multiple parts of the program running simultaneously. (i.e insertion happens at the same time)

Will this create any problem ? Using the same DSN to write the data to the same table in the same database at the same time ?

Will using 2 DSN linked to the same database solve the error or loss of data problem ?

Does the same error happens in the read from database command set also (if it happens simultaneously) ?

Please help.

Thank you in advance.

[MarcoMauri]

Hi Mike!

Are you experiencing an error or are you considering if it can happen?

I usually rely on a producer/consumer architecture when interfacing to a database.

Data to be stored to the DB are queued by the main loop and then saved to DB by the consumer loop.

An other option could be to protect the access to the DB placing it in a single non-reentrant VI (e.g. a functional global).

In this case a writing cannot occour while someone else is writing/reading to the db.

Regards,

Marco