I have tried the fix mentioned here:
But the database in question has a simple password. I can manage to access the database and remove the password. But then, when do the
Open the Immediate Window (Ctrl+G), and enter:
I get an error 3049 Cannot optn database '. it may not be a database that your application recognizes or the file may be corrupt.
When I debug that message it takes me to the line
Set tdf = dbBad.TableDefs("MSysAcces
in the fix code.
I'm wondering if I need to be able to run the part
) and pass on the password THERE rather than trying to open the database and remove the password first.
Can someone help me with this.