As you can tell from my previous posts I am new to COM.

As I am the only VB programmer at work I need to try and do things to the best of my ability and how others might do it.

So this is what I want to do...

I have added a new class to my In-server process to return data from certain tables. For now I want my client app to request ALL Account Names from a table on the database.

I know how to do the SQL bit.

I have decided to use a Collection for this held in my class.

Q. Is this right?

Q. If this is correct can someone guide me further.
Q. If its not has anyone got a better solution?

Hope this makes sense.