I am presently having difficulty connecting to an Access 95 database via an
ODBC driver.  I have two DSN created; one for a SQL Server database and one
for an Access database.  

I have no problems connecting to the SQL Server database.  It's the Access
database that has got me in a snag.  I figured the code would be
similar....but I'm receiving the following run-time error.

Error 3423

You can not use ODBC to import from, export to, or link an external
Microsoft Jet or ISAM database table to your database.

The connection code I am using is as follows:

Set gdb = OpenDatabase("", False, False, "ODBC;DSN;CSAccess;UID=;PWD=;"

If anyone knows what I need to do can you please let me know.

Thanks,
Craig

Here's what I've done.  And it connects to Access & SQL Server:

    Set theWorkspace = CreateWorkspace("ODBCWorkspace", "software", _
        "", dbUseODBC)
    Workspaces.Append theWorkspace
    Set theDB = theWorkspace.OpenDatabase("", False, False,
"ODBC;DSN=CSAccess" +         ";UID=Admin;PWD=;")

BTW I am using DAO 3.5

        Check Project -> References

hth
Vince