how to detect concurrent updates from MS Access database

[222]

Hi...

I would like to know how can LV detect the MS Access database if there is any updates data from others application such as VB6 through the same database.. I do not want the LV to check from the database so oftenly. It will only do the checking / refreshing of data when there is a new data updated by other software (like VB) into the same database. THANKS!!......

[Justin_M]

222,

It sounds like you want MS Access to send an event or callback to your Labview program whenever it receives an update.  I'm definitely no Access expert, and I'm not sure if the program can generate events like that (I've done some searches at Microsoft.com, with no luck so far).  I would suggest going to Microsoft's website to either contact technical support with the question, or post to their forums.  The first step would be figuring out if it's possible to generate such an event, and if so, we can go from there.  If not, the polling method might be the only option.  Here are some links that will help get you started:

Microsoft Access Home

Microsoft Office Access 2003 Help and Support

-Justin

[222]

Thansk Justin.. Will look into it.....