Jump to content

Updating An Access Table Using AutoIT


Recommended Posts

I have a .vbs script that I use when I deploy updates to determine who has run my updates and who hasn't. I just discovered AutoIt and want to throw out .VBS and start using only AU3 scripts. Is there a way to code this in an AutoIt script?

Set rs = WScript.CreateObject("adodb.recordset")

Set objWshNetwork = WScript.CreateObject("WScript.Network")

UserName = objWshNetwork.UserName

Set rs = WScript.CreateObject("adodb.recordset")

dsn="DRIVER=Microsoft Access Driver (*.mdb); DBQ=N:\Steve\SoftwareTracking\SoftwareInstallTracker.mdb;"

rs.Open "SoftwareTracking", dsn, 2, 3

rs.AddNew

rs("UserName") = Username

rs("RisaMasonry10") = "Yes"

rs.Update

rs.Close

Thanks

Steve

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...