protokoll when there is an action in a table

[Markus Frey]

Hi,

I appreciate this group very much!

My question is, if there is a data change in a table, does MS ACCESS '97
automatically potokoll this in any way, and if yes, how can I have access to
this protokoll? - Thanks..

 

[Rick Brandt]

Hi,

I appreciate this group very much!

My question is, if there is a data change in a table, does MS ACCESS '97
automatically potokoll this in any way, and if yes, how can I have access to
this protokoll? - Thanks..

If you are using the native Jet tables no. You would have to use a
database engine that supported table-level triggers like SQL Server. If
you do *all* updates through forms or queries executed from code (which you
should anyway), then you can use events associated with those forms or
procedures to accomplish what you want.