Access Database
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
Access Database

 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM
Author Message
Glenmore
Guest





Posted: Tue Nov 01, 2005 1:51 pm    Post subject: Access Database Reply with 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
Daniel Lai [MVP-Managemen
Guest





Posted: Tue Nov 01, 2005 5:51 pm    Post subject: Re: Access Database Reply with 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...
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 Reply with quote

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 Reply with quote

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
 
Post new topic   Reply to topic    Windows Server Forum Index -> MOM All times are GMT
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB