Code that populates an access database field with the date/time of when the script last ran...

You mentioned script, so I'll assume you mean script and will answer accordingly (no strongly-typed Dims, for example).

The 'chunk' of code you describe might look something like this:

Dim cnn
Set cnn = CreateObject("ADODB.Connection")
cnn.Open = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=AccessDbPathAndFileName"
cnn.Execute "INSERT INTO SomeTable ( SomeField ) VALUES (#" & Now() & "#)"
cnn.Close
Set cnn = Nothing

Of course, you'd have to change the third line of code to reflect your Access database location and name and the fourth line of code to reflect the actual table and field names.

Hope this helps.

Yes, i am talking about a vbs script.

Thanks for the suggestions.  I'll play around with this, thanks for the help.

-Luke

I also should add, there's a tiny typo in my code above (though in testing it doesn't seem to affect execution):
the third line should be
     cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=AccessDbPathAndFileName"

NO EQUAL SIGN between Open and "Provider...".  Sorry for the fat-finger.

OK so i have been working on the suggestions i got. in particular the one i got from pique tech.

I am including the code that i have been working with...  Could someone check the logic?  When i run it in the script i don't get any error but i'm not getting any data in the database.  Any suggestions to get me back on the right path would be greatly appreciated!

Here's the code:

strComputer = "."
Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colItems = objWMIService.ExecQuery("Select * from Win32_LocalTime")

Dim cnn
Set cnn = CreateObject("ADODB.Connection")
cnn.Open  "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\sam\d$\inetpub\wwwroot\luke\scans\database\iava.mdb"

For Each objItem in colItems
cnn.Execute "INSERT INTO dbo_ComputerMasterList (Search_Date) VALUES (#" & objItem.Month & "/" & objItem.Day & "/" & objItem.Year &"#)"
cnn.Execute "INSERT INTO dbo_ComputerMasterList (Search_Date) VALUES (#" & objItem.Hour & ":" & objItem.Minute & ":" & objItem.Second &"#)"
Next

cnn.Close
Set cnn = Nothing

Thanks for the help pique tech.  I'll play around with that and see what i can come up with...  It is a  linked table so i'll look into the sql security config. and see what happens.  I appreciate your help.

Since i'm trying to insert directly into sql...  I'm having troubles figuring out what the proper security configuration should be...  Any suggestions you may have would be greatly appreciated.