If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
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... |
#2
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
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" "Earthman" wrote in message ... 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... |
#3
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
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) On Feb 26, 8:42*am, Earthman wrote: 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... |
#4
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
Earthman wrote:
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/ |
#5
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
Earthman wrote:
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/ |
#6
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
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) "Earthman" wrote in message ... 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... |
#7
|
|||
|
|||
MS Access Desktop Shortcut with excessive target length
|
Thread Tools | |
Display Modes | |
|
|