PowerShell - application.opencurrentdatabase password prompt

Question

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.

Answer 1

Just in case anybody stumbles across this, always double check the permissions on the UNC folder where the database is stored!