PowerShell Script to Query Specified Columns of a .MDB DataBase

Script connects to the .MDB file using user DSN named “MS Access Database” pointing to the .MDB file and then queries the specified columns.

$adOpenStatic     = 3
$adLockOptimistic   = 3
$userName       = $env:USERNAME
$newDbPath       = "C:\Temp\$userName\DPW"
$connectionString   = "DSN=MS Access Database;"
$sourceQuery     = "Select * From Connection"

$objConnection     = New-Object -com "ADODB.Connection"
$objRecordSet     = New-Object -com "ADODB.Recordset"

$objConnection.Open($connectionString) 
$objRecordset.Open($sourceQuery, $objConnection, $adOpenStatic, $adLockOptimistic)

$objRecordset.MoveFirst()
While ($objRecordset.EOF -ne $True) {
  ForEach ($column in "ConnectString", "FilePath", "BackupPath") {
    $objRecordset.Fields.Item("$column").Value    
  }
  $objRecordset.MoveNext()
}

$objRecordset.Close()
$objConnection.Close()

.