This is FANTASTIC code. I too had the issue with needing to find out the users in a back end database. I attempted to use the code of:

cnn.Open "Provider=Micro soft.ACE.OLEDB. 12.0;" & _
"Data Source=" & GetLinkPath & ";"
However, my backend database is password protected.

My GetLinkPath code is:

Public Function GetLinkPath()
On...