Hey everyone my problem is solved. When I instatiated my class module I assumed the variable Conn Set Conn = New ADOConn 'My class module

Would bring back the connection string the same as if I had instatiated it like
Set Conn = New ADODB.Connection

But it does not. SO I have to set a variable equal to the class modules connection string property and now it works