Desktop shortcut for multiple users that goes to same user profile sub directory

Posted on 2010-11-20
Medium Priority
Last Modified: 2012-06-27
Hi all,

I have a front end Access application on a terminal server (Dialog.mdb) that sits in each users subdirectory i.e.

What I'm looking for is a desktop shortuct that I can distribute where it would work for all users
C:\users   is a fixed element
the ResolveIT sub-folder is a fixed element
but obviously the user name is relevant to the logged on user
Question by:Paul-bbc
  • 2
  • 2
LVL 14

Expert Comment

by:Bill Ross
ID: 34179515

Try "%HOMEPATH%\ResolveIT\..."

LVL 14

Accepted Solution

Bill Ross earned 1000 total points
ID: 34179516
OOps.  Saw the db name so try:



LVL 86

Expert Comment

ID: 34179616
That would probably be a Server 2008 (R2)?

if a user has a home drive defined in his properties, then %HomeDrive% and %HomePath% will point to there, not to the local profile folder. The local user profile can be found in %UserProfile%.

Author Comment

ID: 34179754
Bills worked for me, but thanks for your comment oBdA

Author Closing Comment

ID: 34179760
Worked frst time for the particular server/user profile configuration that was set on the terminal server in question so am awarding AAA etc.

Please note.  May not work in all cases, see other comments

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Implementing simple internal controls in the Microsoft Access application.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question