The database connection is being passed to a function called BuildDutyOfCareReps so changing to an ADO connection might require changes to that function as well. Can you post that code as well?

PS. It is not a good idea to post your database username and password on a public forum. You should change that text to protect your data.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia