-
I am using Common Dialog Box to import file (Access Database). I wrote for code following:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Option Explicit
Dim FileName As String
-------------------------------
Private Sub Form_Load
*
*
Set Dbs = OpenDatabase(FileName)
Set Rst = Dbs.OpenRecordset("Query")
*
*
End Sub
Private Sub open_Click()
dlgCommon.ShowOpen
FileName = dlgCommon.FileName
End Sub
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
When i try to run this program,
"Select Data Source" dialog box pops up,
then if i choose "MS Acceess Database",
I am getting error message as following:
"Run-Time error 3423
You cannot use ODBC to import from, export to, or link an
external Microsoft Jet or ISAM database table to your
database."
I can't open database this way?
Do I have to use DirListBox, DriveListBox or TreeView to open and import file?
Please help me!
Thank you in advance.
Kaz
-
It worked fine!
Thank you very much!