I'm using PowerShell to connect to a MS Access database stored on a UNC to run a macro. This is the code I'm using...
$MsAccess = New-Object -ComObject Access.Application
$MsAccess.OpenCurrentDatabase('\*****\db.accdb', $False, 'password')
$MsAccess.Visible = $true
$MsAccess.Application.DoCmd.RunMacro("Macro1")
$MsAccess.CloseCurrentDatabase()
$MsAccess.Quit()
The password I'm supplying is correct as it works when I manually open the database. When I run this code I'm still being prompted to supply the password for the database...

Using the same code works for other password protected databases but just not on this one.
Any help is greatly appreciated.