I use MS Access as my database (do not have SQL Server). I use ODBC to create DSN, open VB and select Standard Exe from New Project dialog, select View|Data View Window to open up Data View, right click on Data Links and select Add a Data Link, select either Microsoft OLE DB Provider for ODBC Drivers or Microsoft Jet 4.0 OLE DB Provider, and set up the connection.
When I try to open the Data link node I've just created in order to add new tables, I get this error message "Unable to establish a connection. Please ensure that the connection properties are correct and that the source is availabel. ActiveX component can't create object"
My friend does samething that I did on his machine and has no problem. There must be something wrong with my VB setting, is it right? Please help me.
Thank you for your response

Mai Nguyen

Use the connect string below, no DSN needed.
replace the MDB with the actual path and file name.

make sure you have Miscrosoft ADO 2.5 or greater in your project references.

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=c:\somepath\mydb.mdb;" & _
           "Uid=admin;" & _
           "Pwd="

look at

http://www.able-consulting.com/ADO_Conn.htm