
Connecting to an Access 95 database via an ODBC driver in VB 5.0
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