Re: Shortcut

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paul Overway (paul_at_I.hate.spam.logico-solutions.com)
Date: 02/17/05 

Date: Thu, 17 Feb 2005 11:57:50 -0500

No API calls required, just instantiate the Access application object you
require and use SysCmd(9) to determine the install dir. Alternatively,
there is some sample VB Script with a white paper on installing Access apps
at site below under Extras...the script can be used to obtain the path from
the registry. 

-- 
Paul Overway
Logico Solutions
http://www.logico-solutions.com
"VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message 
news:4636CA99-7C3B-4C2E-8F99-5BE8C037EA55@microsoft.com...
> Good suggestion.  Although, I do have limitations on a corporate network, 
> I
> can make adjustments in the directory structure (below a base directory) 
> and
> also with the database and workgroup file names.
>
> More than anything else, I'm most challenged with the plethora of 
> potential
> paths to the 'MSACCESS.EXE' file.  Any suggestions for a Windows API call
> would be most appreciated.
>
> Regards,
> VBA Dabbler
>
> "Paul Overway" wrote:
>
>> Ideally, you should try to shorten your UNC paths.  Performance will 
>> suffer
>> with long UNC paths anyway.  Try to get your app at the root of the 
>> share.
>> With shorter paths, I suspect you wouldn't have the issue with the target
>> edit box.
>>
>> -- 
>> Paul Overway
>> Logico Solutions
>> http://www.logico-solutions.com
>>
>>
>> "VBA Dabbler" <VBADabbler@discussions.microsoft.com> wrote in message
>> news:84E0A3A1-6D23-4862-8942-EF83E8EBECF2@microsoft.com...
>> >I have a secured .mdb on a network server with a shortcut setup on the
>> >server
>> > as follows in the target:
>> >
>> > "path to MSACCESS.EXE" "path to database file" /WRKGRP "path to 
>> > workgroup
>> > file"
>> >
>> > I'm at the limit of the characters in the Target editbox, and need to
>> > replace the drive letter reference with '\\servername\spacepath\' for 
>> > the
>> > database file and workgroup file.
>> >
>> > My questions are:
>> >
>> >   1. Short of shortening my paths and file names, how can I make it 
>> > fit?
>> > Can I set and use variables?
>> >   2. Is there a way to bring the application path in for all local 
>> > machine
>> > installations?  (Depending on desktop support's choice of installation
>> > path,
>> > and for different versions of Access.)
>> >
>> > Thanks,
>> > VBA Dabbler
>>
>>
>>

Relevant Pages

  • Re: kbuild make deb patch
    ... > target in any way. ... +# Simple script to generate a deb package for a Linux kernel. ... +# package install and removal. ... +cat <<EOF> debian/changelog ...
    (Linux-Kernel)
  • Re: Deploying Office 07 with Group Policy
    ... computer I tested it on took 30 minutes to install. ... the following script to the Computer Startup Script. ... REM Get ProductName from the Office product's core Setup.xml file. ... REM Set ConfigFile to the configuration file to be used for deployment REM ...
    (microsoft.public.office.setup)
  • Re: ShellExecute...
    ... anyone who tries to write their own install program these days is just crazy. ... and it is absolutely manadatory that EVERY API be checked for ... Only the most naive beginner would think that writing an install script ...
    (microsoft.public.vc.mfc)
  • Re: [opensuse] Editting PATH variable
    ... SuSEconfig script ... ... not knowing what you options you used to install ... If your unfamiliar with Bash a good book is 'Learning the Bash Shell' by ... For Java use editing the PATH variable is NOT required... ...
    (SuSE)
  • Re: KB911280 update problem
    ... Microsoft is working on an amended patch which will address this issue. ... Microsoft advises anyone affected by this to not install the patch and to ... That script is broken by the patch. ... He said he could not write a bug report ...
    (microsoft.public.windowsupdate)