connect to database with jet

#open database
$conn = new-object system.data.oledb.oledbconnection
$conn.connectionstring = "provider=microsoft.jet.oledb.4.0;" `
  + "data source=c:\test\versions.mdb"
$conn.open()

#query results
$query = "select id from machines"
$cmd = new-object system.data.oledb.oledbcommand
$cmd.commandtext = $query
$cmd.connection = $conn
$dr = $cmd.executereader()

while ($dr.read()) {
  $name = $dr.getvalue(0)
  $sp = get-wmiobject Win32_OperatingSystem `
        -property ServicePackMajorVersion `
        -computername $name
  $ver = $sp.servicepackmajorversion

  #open second connection
  $conn2 = new-object system.data.oledb.oledbconnection
  $conn2.connectionstring = "provider=microsoft.jet.oledb.4.0;" `
    + "data source=c:\test\versions.mdb"
  $conn2.open()

  #update table
  $query2 = "update machines set ver = '$ver' where id = '$name'"
  $cmd2 = new-object system.data.oledb.oledbcommand
  $cmd2.commandtext = $query2
  $cmd2.connection = $conn2
  $cmd2.executenonquery()

  #close second connection
  $conn2.close()
}