[dba-SQLServer] Users in SQL Server

Is there something that can be read from SQL Server to discover the count of
and even a list of users logged in to a SQL Server database?  I am moving a
client from an MDB data store to SQL Server and need to get this information
on demand, using VBA.
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com