Updating program from database over Network

My application will have the same program running on several maybe 5 different computers across a network. This program will access a central database on a file server and will add records or delete and modify records.

What I need is a way to detect if the recordset/database has been updated or something that will alert the program when it is update so that I can refresh my datagrids etc.

I do not really want to put a button that the user has to click to refresh the display. Nor do I want the grid to update at regular intervals as that may not be needed and would only use up extra resources.

Any help would be appreciated.

Thanks

Matt Brown

Using a dynamic cursor you will be able to see changes, but I think you need to issue a refresh command to repopulate the local recordset from the file server to see new records ... anyone else?