Trying to get away from polling

[jadams0173]

I currently check a field in a table every 5 seconds to make sure the tables aren't updating. The backend tables are updated via a scheduled task from my PC. The update is written in VB6 that updates the backend tables and the FE is currently access 2000.

I'm trying to get away from the 5 second polling to something more robust. I found this thread222-1342752 in the VB6 forum but I haven't tried it in access yet. Any other thoughts or ideas on how to avoid polling?

 

[Ed2020]

I think you'd need to use something akin to Oracle triggers to avoid polling the table for changes. Unfortunately, MS Access doesn't have anything like this.

Alternatively you could create a temporary file somewhere then use the code here to notify your application of the existence of the file:

http://www.tek-tips.com/viewthread.cfm?qid=719707

Ed Metcalfe.

Please do not feed the trolls.....

 

[jadams0173]

Hey ed. The thread you referenced is the one I was suppose to have referenced in my post. Sorry for the mistake. That was the code I have been playing around with but I've had some small problems with it. I've posted back in the thread I referenced and hope Strongm will reply or at least point me in a direction.

I had hoped to use the code in the thread you linked to and have my update code add a text file to a folder and that in turn would notifiy the access app that the tabels were updating and delete it when the updates were done. But I'm having some issues getting that to work.

I tried to have patience but it took to long! -DW