Hi
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)
Please Helpme!
novicevbp 0 Newbie Poster
vb5prgrmr 143 Posting Virtuoso
novicevbp 0 Newbie Poster
novicevbp 0 Newbie Poster
vb5prgrmr 143 Posting Virtuoso
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.