I am trying to open a MS Access db via CommonDialog1. All is fine untill I click OPEN after selecting the db I want. What I then get is a dialog for ODBC entitled SELECT DATA SOURCE with two tabs: File Data Source or Machine Data Source. If I choose Machine Data Source and then MS Access I get a runtime error 3423 and the message that I cannot use ODBC to import from/export to or link an external Microsoft Jet or ISAM Database table to my database. I am really confused - why does the SELECT DATA SOURCE window appear at all?
If I run debug it fails at the following line of code:
Set db = ws.OpenDatabase(gf_strDbPath)