Live Monitoring

[Kronos]

So I have a split database on a network, with 2 different front ends.
Is there a way to have a, 3rd front end database or run a form on the back end database, running on my computer, and whenever the other 2 users change data to the back end database, the form on my screen instantly runs me.refresh.
I have searched and searched in the help file and on this site for a solution.
I was also wounding if it was possible to have code in one of the 2 front ends to trigger a refresh in a different database.

Basically, is the following possible in any shape or form:
Database(1) on computer (1), ie front end, Adds new data to the back end tables, then Database (1) on computer (1) triggers a form, another front end or a form on the back end file, that is opened on Database(2) on computer (2) to refresh

I hope this makes sense and thanks for any help on this.

 

[Pat Hartman]

Access (Jet) does not support triggers so there is no way to notify you of changes at the table level. You could add code to your forms to send emails or something but I don't think that is what you want. You can add a timer event to your form that automatically requeries the form at specified intervals. Don't forget that requery will reposition the form to the first record in the recordset so that can be annoying if you keep loosing your place in a recordset. Refresh only picks up updates. It does NOT pick up new records.

Warning, when you have an active timer event, do NOT try to edit code. First close the form with the timer event before trying to make object changes to the database. Timer events cause strange things to happen and cause cause corruption if you are not careful.

 

[Kronos]

Thanks

Thank you much for the reply, especially for that last part, I found the timer function yesterday, and it kept on screwing up, and I think that is why. But thanks again.