Retrieving List of users

[Stephen Haley]

My clients would like to sell a simultaneous user licence while I can do
this easily with jet is there a way I can get a list of current users
attached to a database on a sql server from within vba?

rgds
stephen