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