I believe I have found the code where I am getting this run time error which I paste below:

Dim objdatabase As Connection 'ODBC

Set objdatabase = wrkODBC.OpenConnection("Connection1", , , "ODBC;UID=" & SQL_ID & ";PWD=" & SQL_PASS & ";DSN=" & SQL_DSN)

From what I have seen in the VB help file, the construct of the second code line is this:

Set connection = workspace.OpenConnection (name, options, readonly, connect)

Could someone please suggest what part of this line of code is likely to be affected if you upgrade your Operating System? From what I can tell the function "Connect" has been described in this code and refers to some external database(s). (Just thinking out loud) perhaps the code is refering to databases which are no longer in existence or perhaps have been renamed. Does the "Connect" function somehow refer to the location of external database(s) because there is no obvious pathname specified in the code. Any thoughts guys would be much appreciated!

hi there...

did you ODBC connection work fine???

you have no path reference b/c you are using ODBC to connect...



HTH

Gonzalo

I suspect that the DSN you are supplying in SQL_DSN became lost with the upgrade.

Did you reinstall VB after the upgrade?
Marco