Monitoring MS-Access (mdb) changes

  • Thread starter Thread starter Nicolas
  • Start date Start date
N

Nicolas

Hi,
I have an mdb file on computer A and I would like to monitor that file from
Computer B for changes like when a new row has been added to a table.

I did try fileystemwatcher but with no success.
Everytime a new row is add, by a third party application, it trigers
lastwrite filter but then when I want to query and find out about that new
row (SELECT.... FROM...) then the mdb is creating an event Lastwrite,
therefore I'm going into a loop.

The database (mdb) is used by another application that I do not have any
control.

Any idea will be appreciated
Thank you
 
Nicolas said:
Hi,
I have an mdb file on computer A and I would like to monitor that file from
Computer B for changes like when a new row has been added to a table.

I did try fileystemwatcher but with no success.
Everytime a new row is add, by a third party application, it trigers
lastwrite filter but then when I want to query and find out about that new
row (SELECT.... FROM...) then the mdb is creating an event Lastwrite,
therefore I'm going into a loop.

The database (mdb) is used by another application that I do not have any
control.

You can only pull data periodically to spot changes. Be aware that a
change immediatelly followed by another change undoing the first one can
not be spotted at all this way if both fall into the same period.
 
I thanks but I think that I may do the following which I did a while ago and
forgot about it.
enabling filesystemwatch then when an event is triggered first thing will be
to disable the filesystemwatch, then do my request on the MDB and then
re-enable the FileSytemWatch again. This way I release the constent
periodical checking. I did need the closest response time to the event
occurence.

May be there is another way. Let me know.
Thanks
 
Back
Top