have him add a Dispose Method to the module to handle all the module scoped objects

and end each function with

dispose()

return moDS

Public sub Dispose()

moSelCmd = nothing           

moDA = nothing           

moDataConn.close

modataconn = nothing

they wont be the same if all users dont have subscriptions.  doing a left join should be the same i think.

it would seem your data table has to have customer, period, goal in it and you should just be able to join it.

select customername, programname, goalname,

customers c, programs p,...

went thruough all of them and none were set to autoclose

didnt think to look for it right away because if it was closing i would expect to see starting database appear...

select clientid, coursedate, max([course code]) coursecode

from [course bookings] b,

(           SELECT     [client id] clientid, MAX([course date]) coursedate

            FROM        dbo.[course bookings]

            GROUP BY  [client id]

) as d

where d.clientid = b.[client id]...