H
Hong
I converted an ACCESS 97 db to ACCESS 2000. I have some
link tables uses ODBC DSN to connet to Oracle db. After
the conversion, I refered the DAO 3.6 instead of default
ADO and I checked the syntax, it has no compling errors. I
also took off the ADO from the reference to make sure it
is not using ADO. But I kept on getting the run time error
3151: ODBC connection to the DSN failed when I open the
current db and then some recordset and call another
function in which it opens the currentdb and then open
recordset too. I think the problem related to open mutiple
recordsets under currentdb. But I cannot close the first
recordset before I open the second one. If I just open one
connection with one recordset, it seems working fine. It
works fine under ACCESS 97 too. Please advice me on how to
solve this problem.
link tables uses ODBC DSN to connet to Oracle db. After
the conversion, I refered the DAO 3.6 instead of default
ADO and I checked the syntax, it has no compling errors. I
also took off the ADO from the reference to make sure it
is not using ADO. But I kept on getting the run time error
3151: ODBC connection to the DSN failed when I open the
current db and then some recordset and call another
function in which it opens the currentdb and then open
recordset too. I think the problem related to open mutiple
recordsets under currentdb. But I cannot close the first
recordset before I open the second one. If I just open one
connection with one recordset, it seems working fine. It
works fine under ACCESS 97 too. Please advice me on how to
solve this problem.