X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Need To Know The Path To Runtime, Office 2007    
post Apr 3 2010, 03:57 PM

Posts: 528
Joined: 19-November 08
From: Chicago

I am creating an application which will deployed at each users computer. The user will operate th application in the runtime environment.
I am writting a script which will be launched by an icon on the user's desktop. This script will do a few preparations and will then launch the application. In order for this to work properly, I need to know the path to the runtime executible file. I cannot seem to figure out what it is.
Please help.
Go to the top of the page
post Apr 3 2010, 04:33 PM

Utterly Banned
Posts: 7,038
Joined: 5-December 02

Search your computer for MSACCESS.EXE
Go to the top of the page
post Apr 3 2010, 05:48 PM

UtterAccess VIP
Posts: 2,633
Joined: 12-April 07
From: Edmonton, Alberta Canada

Do you need this path from inside of access code?
On side of access, the path name to access is:

In a script, you can pull the path name, the reg key is:
And, if you read my article here, I have a sample install inno script:
Deploying updates for Access 2007 runtime
Name: "{userdesktop}\Rides Reservations (Lodge)";
FileName: "{reg:HKLM\SOFTWARE\Microsoft\Office\12.0\Access\
Parameters: """{app}\RidesXP.accde""
/runtime"; IconFilename: "{app}\Rides.ico"; comment: "Lodge Booking System"

The above is broken over several lines and shows how to do this in Inno. In fact, it part of my install scripts I DO NOT normally share in public.
Anyway, the above will give you an idea as to how your Inno script can read a value from the registry for installing. And, you can also read that value in a windows script (VBS) if you wish. However, I think adopting the Inno installer is a great solution + approach for updates and setting things up like shortcuts to your desktop. I give more info on Inno in the above article.
By the way, I don't recommend a routine to scan the whole computer. These scanning routines can take a VERY long time on machines with large hard drives (especially since I have file indexing turned off). It is a BAD day when some program starts to scan my drive, as now I am stuck for a VERY long time watching my drive spin like crazy and slow down everything else I am doing. I am just pointing out that many people will have a high disregard for your software if it has to fire off some hard drive scanning routine. So, if you must resort is to scan, then prompt or ask the user for such permission, as they might not want to do that long system task at that point in time.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Go to the top of the page
post Apr 3 2010, 08:49 PM

Posts: 528
Joined: 19-November 08
From: Chicago

Brian and Albert,
Thank you both for your advice. Your suggestions are very helpful.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    24th June 2018 - 12:38 AM