The User Name property returns the name used in a particular database, which can be different than a login name.
object.Properties("User Name")
object
Expression that evaluates to an object in the Applies To list.
adBSTR
Read-only
DBPROP_USERNAME