
Cannot connect to an Access DSN using ODBC!
Hello Everyone:
It is the first time I use ODBC to connect to my Access Database.
1) In ODBC Admin, I added a new DSN called "ABC" to the User DSN and the DB
path is c:\Biblio.mdb;
2) In my VB from, I have a DataControl "Data1" and a DBGrid connected to the
"Data1". The code is following:
Private sub Form_Load( )
Data1.connect = "ODBC;DSN=ABC"
End sub
But when I try to run the program, it give me the following error
message:
"You cannot use ODBC to import from, export to, or link an external Microsoft
Jet or ISAM database table to your database."
Does it mean I cannot connect Access Jet Database using ODBC?
Can anyone please tell me why it doesn't work and how I can connect
to the Access or other type of Databases using ODBC?
Thanks in Advance!
.