user id and password(ADO)

Hi,


Everytime I want to make a form/subform, I have to open connection to my remote server using ADO, I have to make Connection.OPEN "DSN: ....".

Is there anyway that I can use the above line only one time ?? At the moment I am using modified(to suit me better) microsft class from "data form wizzard with option class"

I succeed in making the above class into *.dll...the problem is it always give me mesg "The operation requested by the application is not allowed if the object class is closed" when I use this line "set DataControl.RecordSource = adoObject.rsObject"

Thanks.

If you have crated a class then make your class public when you declare it. I was going to suggest making a module that inluded public functions that returned the data that you need for the connections. Or make the connection you are using Public.