Terminal Server/Citrix question

I have some users that will be accessing an access database from a Citrix Metaframe configration.

When some users login, they will be give a shared directory on the network M:\ drive.
Other users will be given a shared directory on the network U:\ drive.

I don't have any control over this.  What I would like to be able to do is determine through vba if the current user has an active M:\ drive mapped or an active U:\ drive mapped.

Can I do that in vba?
snyperjAsked:
Who is Participating?
 
Michael VasilevskyConnect With a Mentor Solutions ArchitectCommented:
e.g.

If Not Dir("U:\") = vbNullString Then
     'folder exists
else
     'folder doesn't exist
end if
0
 
Michael VasilevskySolutions ArchitectCommented:
Should be able to use Dir()
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.