detect table changes

[vasah20]

Hi -

Is there a way to detect that changes to a table have been made? I saw in Google Groups that changes to a table can be detected by analysing the definition, but I couldn't find any accompanying code.

Any help/strategies on this would be appreciated.

TIA

 

[MichaelRed]

Ms. A. does not include record triggers.


The only way for this is to FORCE all recordset operations through BOUND FORMS and trap the update event(s). Wheather you then do a notification or record the changes is up to the program / procedure(s). If you choose the notification process, you need to be careful that the process sends the notification messag(s) to the correct object, and that the process does not wait for acknowlegement.


MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[cmmrfrds]

If you are asking about changes to the table definition that can be found in the hidden table called MSysObjects.

There is a field called DateUpdate in the MSysObjects table.