| Author |
Message |
Glenmore
Guest
|
Posted:
Tue Nov 01, 2005 1:51 pm Post subject:
Access Database |
|
|
I need to be able to monitor an Access database via MOM - each time an
additional row is added into a table - I need an event to be generated so
that it can be alerted on.
Is this possible - I have created a Generic single-line log file provider
but this does not seem to work - rows have been added to the table but MOM
has not generated an event.
Failing that, is it possible to generate an event when a file has been
updated - i.e. timestamp changed ?
Thanks |
|
| Back to top |
|
 |
Daniel Lai [MVP-Managemen
Guest
|
Posted:
Tue Nov 01, 2005 5:51 pm Post subject:
Re: Access Database |
|
|
Hello,
Thank you for your posting!
I think, you can store that Database in a folde, enable auditing, and then
enable Audit Policy.
After that, Create a new Event Rule to collect the Security Log.
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Glenmore" <Glenmore@discussions.microsoft.com> wrote in message
news:15787759-C409-4D48-919F-684D52FEAC01@microsoft.com...
| Quote: | I need to be able to monitor an Access database via MOM - each time an
additional row is added into a table - I need an event to be generated so
that it can be alerted on.
Is this possible - I have created a Generic single-line log file provider
but this does not seem to work - rows have been added to the table but MOM
has not generated an event.
Failing that, is it possible to generate an event when a file has been
updated - i.e. timestamp changed ?
Thanks |
|
|
| Back to top |
|
 |
Glenmore
Guest
|
Posted:
Tue Nov 01, 2005 5:51 pm Post subject:
Re: Access Database |
|
|
Thanks Daniel,
Is there anyway the access database itself can be queried.
Thanks
Nick
"Daniel Lai [MVP-Management Infrastructur" wrote:
| Quote: | Hello,
Thank you for your posting!
I think, you can store that Database in a folde, enable auditing, and then
enable Audit Policy.
After that, Create a new Event Rule to collect the Security Log.
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
http://msmvps.com/daniel
"Glenmore" <Glenmore@discussions.microsoft.com> wrote in message
news:15787759-C409-4D48-919F-684D52FEAC01@microsoft.com...
I need to be able to monitor an Access database via MOM - each time an
additional row is added into a table - I need an event to be generated so
that it can be alerted on.
Is this possible - I have created a Generic single-line log file provider
but this does not seem to work - rows have been added to the table but MOM
has not generated an event.
Failing that, is it possible to generate an event when a file has been
updated - i.e. timestamp changed ?
Thanks
|
|
|
| Back to top |
|
 |
davidtyra@hotmail.com
Guest
|
Posted:
Tue Nov 01, 2005 9:51 pm Post subject:
Re: Access Database |
|
|
Not unless there is some way you can get the database to generate an
event when it adds an entry to the database. That would probably take
some kind of scripting or programming to make happen (but then I am not
the world's foremost authority on Access)...
Regards,
David Tyra |
|
| Back to top |
|
 |
|
|
|
|