I need help with this code. I need to click a command button in excel and open Access to a certain "Form" and Hardcode the password.
I get a code "File name or class name not found during automation operation"
Any help would be greatly appreciated
'Open a form in Access
Dim App As Object
Set App = GetObject("\\Dtcnas-ilsp002\mandatory\Analysts - Working Files\Carol\Demo\Volume.mdb;Jet OLEDB:Database Password=OPPS;")