UtterAccess.com
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    
 
   
bizhelp9
post Apr 3 2010, 03:57 PM
Post#1



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


Hi,
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.
Thanks,
Dave
Go to the top of the page
 
Bob_L
post Apr 3 2010, 04:33 PM
Post#2


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



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


UtterAccess VIP
Posts: 2,704
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:
CODE
syscmd(acSysCmdAccessDir)

In a script, you can pull the path name, the reg key is:
HKLM\SOFTWARE\Office\12.0\Access\InstallRoot\Path
And, if you read my article here, I have a sample install inno script:
Deploying updates for Access 2007 runtime
http://www.members.shaw.ca/AlbertKallal/RunTime/Index.html
CODE
Name: "{userdesktop}\Rides Reservations (Lodge)";
FileName: "{reg:HKLM\SOFTWARE\Microsoft\Office\12.0\Access\
InstallRoot\,Path}MSACCESS.EXE";
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
kallal@msn.com
Go to the top of the page
 
bizhelp9
post Apr 3 2010, 08:49 PM
Post#4



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


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


Custom Search


RSSSearch   Top   Lo-Fi    10th December 2018 - 02:36 PM