Solved

Evt Logs import into MS Access

Posted on 2007-03-26
4
989 Views
Last Modified: 2008-02-01
Hi all, trust you are well.

Question: Does anyone know if there is a way in MS Access, without the use of 3rd party apps, a way to read in the Event logs of a pc (.evt files). I'm writing a small database to be able to query the security log files for specific information.

Thanks
Sean
0
Comment
Question by:SeanNij
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 250 total points
ID: 18798263
This links might help:

http://www.microsoft.com/technet/scriptcenter/guide/sas_log_iwbi.mspx?mfr=true

Maybe set a reference to the Scripting LIbrary ....

also

http://www.softwareshelfdistribution.com/files/productsFeatures.asp?ID=150&page=_features

There has got to be a way

mx
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 250 total points
ID: 18799092

  It's a bunch of API Calls.  Found some code here:

http://www.mvps.org/st-software/VB_Code_LJ.htm

  But your not allowed to distribute the source.  It's also VB6 (should convert easily though).  Either use as is and distribute as an MDE or read through and figure out what API calls are required (just open the class modules in notepad).

JimD
0
 
LVL 1

Author Comment

by:SeanNij
ID: 18805903
Thanks. Between the two i'm managing - well getting there - well almost....

But thanks
0
 
LVL 75
ID: 18805923
Wow ... that was a long shot for me ... and thanks for give JD some points.

If you could, post back what you actually do ... because this is one of those off the wall things - so to speak ... that might be good to know somethime.

mx
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question