Solved

Evt Logs import into MS Access

Posted on 2007-03-26
4
993 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

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…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

752 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