Access ODBC with VB4 connect problem 
Author Message
 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    



Thu, 11 Mar 1999 03:00:00 GMT  
 Access ODBC with VB4 connect problem



Quote:
> 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:...

> "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    

MS Access can't connect to ISAM database ( such as Foxpro, dBASE, Paradox,
Access ) using ODBC connection.


Fri, 12 Mar 1999 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. VB4 ODBC connect to SQL Server problem

2. VB4 Oracle7 ODBC - Problems connecting from VB IDE

3. VB4 Oracle7 ODBC - Problems connecting from VB IDE

4. VB4 connect string with ODBC driver problem solution

5. VB4 16bit, ODBC, Connect String, Hanging problem. SOLUTION

6. VB4 Oracle7 ODBC - Problems connecting from VB IDE

7. Help: Problem connecting VB3 app to Access 2.0 w/ODBC in Win-OS/2

8. Help!problem using ODBC to connect to access.

9. Help: Problem connecting VB3 app to Access 2.0 w/ODBC in Win-OS/2

10. Problem in adding record in an ODBC-connected Access database

11. VB4 - ODBC - MS SQLServer Data Access Related Problem

12. VB4 - ODBC - MS SQLServer Data Access Problem

 

 
Powered by phpBB® Forum Software