watchdog

[tracktraining]

Hi All,

I am considering about coding a watchdog into my MS Access database, but am
unsure if i really need it. What are your thoughts about it? if I should have
a watchdog, how do i go about writing this code? Any advice is greatly
appreciated.

Thanks!

 

[Banana]

Maybe a bit elaboration will help us understand what you are really after.

For instance, if by 'watchdog' you mean a mean of logging all changes
your users makes, then the de facto official phrase would be "audit
trail" which if you google for using keyword like "ms access audit
trail", you're likely to find many hits on this.

On the other hand, if by watchdog, you want something to secure the
database, then you need to be specific on what/how to secure the
database. The trick is that it depends a lot on environment and
granularity you need.

For example if all you need is to keep riff-raff out, then you only need
Windows' file permission set to allow only actual users into the folder
where the Access files are contained. But if you want to have different
permissions between groups of users (e.g. data entry operators and
manager) then we need to know whether we're using an Access backend, or
a RDBMS backend, how it's all setup and what is your requirement.

I hope this help illustrate some questions you may want to ask.

 

[John W. Vinson]

Hi All,

I am considering about coding a watchdog into my MS Access database, but am
unsure if i really need it. What are your thoughts about it? if I should have
a watchdog, how do i go about writing this code? Any advice is greatly
appreciated.

Thanks!

As banana says, some more detailed definitions would help.

A watchdog to keep the neighborhood teenagers out of your back yard and a
watchdog to protect your high-security defense base from skilled and
determined foreign agents will probably need to be different breeds and
require different training. The same applies in the database realm...

 

[tracktraining]

thanks all for your advices and humor.

i need to do more thinking about this matter before i ask my next question.

Thanks!