Without a password, I can easily import the access file, but when it is password protected, it just errors. The method i'm using is shown below: Process
The error with a password protected file is shown below: Error
The suggested method to open PW protected Access files are is:
Set db = OpenDatabase("C:\myDB.accdb"), False, False, "MS Access"; PWD="somePassword")
The issue now is:
The script shows that it will open the database using the hardcoded password, but how do I tell the Data -> Get Data -> From Database -> From Microsoft Access Database, to use that password when importing?