Powershell script to run a query against an MS Access database, getting unexpected token error

No file attached, but the error is probably due to your not using the "real" double quote (ASCII 34).
Have a close look at the double quotes in your script above - several of them are "pretty" ones (<“> instead of <">), probably due to copying from a web site or using a Word processing software instead of a text editor to create your script.
The connection string should be just one single string, with the elements separated by ';'.
https://msdn.microsoft.com/en-us/library/ms254500(v=vs.110).aspx

$path = "C:\test\alms.mdb"
$systempath "C:\test\almssys.mdw"
$adOpenStatic = 3
$adLockOptimistic = 3

$cn = New-Object -ComObject ADODB.Connection
$rs = New-Object -ComObject ADODB.Recordset

$cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $path;Jet OLEDB:System database=$Systempath")
$rs.Open("Update Userlogins Set LoggedIn = 0", 
  $cn, $adOpenStatic, $adLockOptimistic)

$rs.MoveFirst()
Write-host "Success"

Select allOpen in new window

Hi oBda,

Just tried your script I'm still getting the same error.

Any ideas?

Thank you.

"Same error" doesn't help at all since you didn't post the error in the first place.

Hi oBda,

My apologies the script:

$path = "C:\test\oaserver.mdb"
$systempath "C:\test\oa.mdw"
$adOpenStatic = 3
$adLockOptimistic = 3

$cn = New-Object -ComObject ADODB.Connection
$rs = New-Object -ComObject ADODB.Recordset

$cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $path;Jet OLEDB:System database=$Systempath")
$rs.Open("Update Userlogins Set LoggedIn = 0", 
  $cn, $adOpenStatic, $adLockOptimistic)

$rs.MoveFirst()
Write-host "Success"

Select allOpen in new window

The error:

At C:\OpenAlmsMaxUserClear.ps1:2 char:13
+ $systempath "C:\test\oa.mdw"
+             ~~~~~~~~~~~~~~~~
Unexpected token '"C:\test\oa.mdw"' in expression or statement.
    + CategoryInfo          : ParserError: (:) [], ParseException
    + FullyQualifiedErrorId : UnexpectedToken

The database names have changed from the initial question. But the same issue.

Thank you.

Missed that; just a "=" missing:

$path = "C:\test\alms.mdb"
$systempath = "C:\test\almssys.mdw"
$adOpenStatic = 3
$adLockOptimistic = 3

$cn = New-Object -ComObject ADODB.Connection
$rs = New-Object -ComObject ADODB.Recordset

$cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $path;Jet OLEDB:System database=$Systempath")
$rs.Open("Update Userlogins Set LoggedIn = 0", 
  $cn, $adOpenStatic, $adLockOptimistic)

$rs.MoveFirst()
Write-host "Success"

Select allOpen in new window

Hi oBda,

One last query if I may, I realize this outside the bounds my initial query. How do I include a username/password in the connection string?

This in relation to following error that has occurred:

Exception calling "Open" with "1" argument(s): "Not a valid account name or password."
At C:\OpenAlmsMaxUserClear.ps1:9 char:1
+ $cn.Open("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = $path;Jet OLEDB:Syste ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : COMException

http://www.w3schools.com/asp/ado_ref_connection.asp isn't providing with many details.

Thank you.

Thank very much for your help.  ADO classic connections info is hard to find, guess it's legacy now days.

Cheers.

For connection strings look at www.connectionstrings.com, obviously.

HI Qlemo,

Thank you for the site, bookmarking this one.