MS Access Desktop Shortcut with excessive target length

[Earthman]

I am trying to create a desktop shortcut to launch a MS Access application,
the the target length seems to be too long - it doesn't fit in the target
field of the shortcut properties form. Basically the target string is:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Documents and
Settings\This user\My Documents\Customers\Customer Name\Financial
Folder\application.mdb" /WRKGRP "C:\Documents and Settings\This user\My
Documents\Customers\Customer Name\Financial Folder\\MSASecurity.mdw"
Note that this is longer than 256 characters, which I believe to be the limit.

Thoughts on ways to get around this?

Running Windows XP Pro with Office Pro 2007.
Thanks...

 

[M Skabialka]

Try this (unless you have more than one version of Access on your PC)

MSACCESS.EXE "C:\Documents and
Settings\This user\My Documents\Customers\Customer Name\Financial
Folder\application.mdb" /WRKGRP "C:\Documents and Settings\This user\My
Documents\Customers\Customer Name\Financial Folder\\MSASecurity.mdw"

 

[a a r o n . k e m p f]

why don't u just right-click drag from the Access file (UNC) to the
desktop?

workgroup security isn't even enabled in Access 2007 (format)

 

[Tony Toews [MVP]]

I am trying to create a desktop shortcut to launch a MS Access application,
the the target length seems to be too long - it doesn't fit in the target
field of the shortcut properties form. Basically the target string is:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Documents and
Settings\This user\My Documents\Customers\Customer Name\Financial
Folder\application.mdb" /WRKGRP "C:\Documents and Settings\This user\My
Documents\Customers\Customer Name\Financial Folder\\MSASecurity.mdw"
Note that this is longer than 256 characters, which I believe to be the limit.

One alternative would be to use the Auto FE Updater which would have drastically
shortened paths and additional functionality. For more info on the free Auto FE
Updater utility see http://www.autofeupdater.com to keep the FE on each PC up to
date.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[Tony Toews [MVP]]

Note that Aaron's statement is somlewhat accurate but misleading. ACCDB files no
longer support work group security but MDB files do. You are probably aware of this
but I felt I shuold clarify Aaron's response.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[david]

C:\PROGRA~1\Microsoft Office\Office12\MSACCESS.EXE"
"C:\DOCUME~1\This user\MYDOCU~1\customers\Customer
Name\FINANC~1\application.mdb"
/WRKGRP "C:\DOCUME~1\This user\MYDOCU~1\Customers\Customer
Name\FINANC~1\MSASecurity.mdw"


or like this:

%myaccesspath% %customers%\Customer Name\FINANC~1\application.mdb
/WRKGRP %customers%\Customer Name\FINANC~1\MSASecurity.mdb


where you have set up environment variables called
myaccesspath
and
customers

Note that I have not tried the second method with spaces in the customer
name,
so I don't know if you can include environement variables inside a quoted
string.

(david)

 

[joelgeraldine]

l!l!l!nnnnn

C:\PROGRA~1\Microsoft Office\Office12\MSACCESS.EXE"
"C:\DOCUME~1\This user\MYDOCU~1\customers\Customer
Name\FINANC~1\application.mdb"
/WRKGRP "C:\DOCUME~1\This user\MYDOCU~1\Customers\Customer
Name\FINANC~1\MSASecurity.mdw"


or like this:

%myaccesspath% %customers%\Customer Name\FINANC~1\application.mdb
/WRKGRP %customers%\Customer Name\FINANC~1\MSASecurity.mdb


where you have set up environment variables called
myaccesspath
and
customers

Note that I have not tried the second method with spaces in the customer
name,
so I don't know if you can include environement variables inside a quoted
string.

(david)