Solved

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

Posted on 2010-11-20
5
376 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

910 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

25 Experts available now in Live!

Get 1:1 Help Now