Run time error: 3151: ODBC connection failed

H

Hong

I converted an Access 97 db to an Access 2000 db. I
referenced DAO 3.6 and took away the ADO .1. But I kept on
getting "Run time error 3151. ODBC connection to the DSN
failed" message when one of the function in the module was
called in which it opens the current db and then create
some recordset and call another function in which it opens
the currentdb and then create another recordset too. I
think the problem related to open mutiple recordsets under
currentdb. If I just open one connection with one
recordset, it seems working fine. It works fine under
ACCESS 97 too. I have already relinked all the tables
after the conversion. Please advice me on how to solve
this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting a DA-ODBC error number 3151 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Error 3151 - Connection Failed 0
ODBC Error 3151 on conection of MYSql ODBC Connection 0
Run Time Error 3151: ODBC Connection Failed 0
Connection failed error number 3151 3
Add record with ODBC Connection 3
Open recordset fails with ODBC connection 4

Top