msaccess.exe location

[Guest]

Greeting,
I plan to deploy an Access 2000 application to my users. They install
Access in different location, half in C:\Program Files\Microsoft
Office\Office, another half in
"C:\Program Files\Microsoft Office\Office10.
For the shortcut, how do I put the correct path for the Target? Or I copy
two shortcut for each users?
Thanks for your kindly advise.

 

[Albert D. Kallal]

Well, you will need something to get/grab the shortcut...

For a2003, the install location is

HKLM\SOFTWARE\Microsoft\Office\11.0\
Access\InstallRoot\Path

So, above + msaccess.exe would be the full path name.

Office 11 = 2003
10 = 2002
09 = 2000

You can also get the full pathname in code in ms-access with

SysCmd(acSysCmdAccessDir) & "msaccess.exe"

The problem is not finding the path name, but you not mentioned how you will
create you shortcuts...

 

[Tony Toews]

I plan to deploy an Access 2000 application to my users. They install
Access in different location, half in C:\Program Files\Microsoft
Office\Office, another half in
"C:\Program Files\Microsoft Office\Office10.
For the shortcut, how do I put the correct path for the Target? Or I copy
two shortcut for each users?

What do you mean by deploy? Are you using the Access runtime?

How are you creating the shortcut?

If you have no parameters you are passing, such as Work Group name
then you need only to create the path and name of the MDB file.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Guest]

Hi Al,
Thanks for the input. My current application is not split, all users run
thier shortcut to share one mdb file in the file server. I plan to split to
FE/BE. Give each user an FE . So when I said Deploy, I mean create a batch
file, to copy the FE file & Shortcut to each users.
Now each user do have a shortcut, the target is: "Access
path+msaccess.exe" "file server path +myApplication.mdb".
For the new shortcut, I got the shortcut from My Access folder, in the
Target I then append the location of FE. So it will be "Access path
+msaccess.exe" "FE location+myApplciation.mdb". Seems you have some magic way
to create shortcut?
Thanks a lot.

 

[Tony Toews]

So when I said Deploy, I mean create a batch
file, to copy the FE file & Shortcut to each users.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm