
Access ODBC with VB4 connect problem
I am trying to connect to an Access 2.0 (Northwind Traders) database
using VB4-16bit variety. I have tried the following code snippet and
continuously {*filter*}out:
Private Sub Command1_Click()
Dim db As Database
Dim SQL As String
Dim Dset As Recordset
Set db = OpenDatabase("", False, False, "ODBC; DSN=Nwind;
UID=Admin;Pwd=")
------
Whenever I do this, it stops right on the Set db statement with
"Error 3423, you cannot use ODBC to attach an external MS Access or
ISAM table to you database."
I'm not trying to attach anything, I'm just trying to read the dumb
thing. What am I doing wrong?
Eric {*filter*}
Atlanta, GA USA