Solved

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

Posted on 2010-11-20
5
375 Views
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.
C:\Users\Bob\ResolveIT
C:\Users\Paul\ResolveIT
C:\users\Jennifer\ResolveIT

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
0
Comment
Question by:Paul-bbc
  • 2
  • 2
5 Comments
 
LVL 14

Expert Comment

by:Bill Ross
ID: 34179515
Hi,

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

Bill
0
 
LVL 14

Accepted Solution

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

"%HOMEPATH%\ResolveIT\Dialog.mdb"

Bill

0
 
LVL 83

Expert Comment

by:oBdA
ID: 34179616
That would probably be a Server 2008 (R2)?
"%UserProfile%\ResolveIT\Dialog.mdb"

BillDenver,
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%.
0
 

Author Comment

by:Paul-bbc
ID: 34179754
Bills worked for me, but thanks for your comment oBdA
0
 

Author Closing Comment

by:Paul-bbc
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
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now