Access ShortCut

  • Thread starter Thread starter luis_a_roman via AccessMonster.com
  • Start date Start date
L

luis_a_roman via AccessMonster.com

I set up a short cut in windows and specified the following information;
(1) In the short cut target I typed; "\\ftwdoors\JSFITCoord\acWKspace\F-35
Dash Board\Tactical DashBoard.mdb" / runtime
(2) In the Start in I typed:"\\ftwdoors\JSFITCoord\acWKspace\F-35 Dash Board"

However, when I click the short cut I get an error: "Windows can not find
\\ftwdoors\JSFITCoord\acWKspace\F-35 Dash Board\Tactical DashBoard.mdb"

Then I get a message that says " The command line that you specified contains
a command that Microsoft Windows does not recognized".

Can someone provide me some assistance? Your collaboration with this will be
appreciated.

Luis
 
All I ever do to create shortcuts to access appls (regardless of whether I'm
using the runtime environment or not) is right-click and drag the file name
from my MyComputers file listing to the desktop and choose Create Shortcut.
If I were you I would just delete that shortcut and do a click-and-drag to
create a new one.
If you want to make the existing shortcut work, Here's what I think you need:

for target, C:\ftwdoors\JSFITCoord\acWKspace\F-35Dash Board\Tactical
DashBoard.mdb

I think you need the fully qualified path name and file name. I don't think
you need the / runtime. If you're set up to run appls in the runtime
environment it should do that automatically.

For Start In you want the path name up through the last directory, without
the filename. I'm not even sure that part is necessary.
 
Alex said:
Try to add a path to msaccess.exe:
"C:\program files\offoce\msaccess.exe" "\\ftwdoors\JSFITCoord\acWKspace\F-35
Dash Board\Tactical DashBoard.mdb" / runtime
I set up a short cut in windows and specified the following information;
(1) In the short cut target I typed; "\\ftwdoors\JSFITCoord\acWKspace\F-35
Click to expand...
[quoted text clipped - 14 lines]
Luis
Click to expand...
Click to expand...
Alex tried your suggestion. It corrected the first problem regarding not
fouding MS Access. However, for some reason it does not like / runtime.

It still give me an error. Other suggestions, please.
 
Jim said:
All I ever do to create shortcuts to access appls (regardless of whether I'm
using the runtime environment or not) is right-click and drag the file name
from my MyComputers file listing to the desktop and choose Create Shortcut.
If I were you I would just delete that shortcut and do a click-and-drag to
create a new one.
If you want to make the existing shortcut work, Here's what I think you need:

for target, C:\ftwdoors\JSFITCoord\acWKspace\F-35Dash Board\Tactical
DashBoard.mdb

I think you need the fully qualified path name and file name. I don't think
you need the / runtime. If you're set up to run appls in the runtime
environment it should do that automatically.

For Start In you want the path name up through the last directory, without
the filename. I'm not even sure that part is necessary.
I set up a short cut in windows and specified the following information;
(1) In the short cut target I typed; "\\ftwdoors\JSFITCoord\acWKspace\F-35
Click to expand...
[quoted text clipped - 11 lines]
Luis
Click to expand...
Click to expand...

You are correct but my intent is to use "runtime" to hide the code behind the
application. In order words I don't know anyone else to see the code. If you
have solution to this conodrum, please help.. Thank you fo your patience and
collaboration.
 
Alex said:
Try to add a path to msaccess.exe:
"C:\program files\offoce\msaccess.exe" "\\ftwdoors\JSFITCoord\acWKspace\F-35
Dash Board\Tactical DashBoard.mdb" / runtime
I set up a short cut in windows and specified the following information;
(1) In the short cut target I typed; "\\ftwdoors\JSFITCoord\acWKspace\F-35
Click to expand...
[quoted text clipped - 14 lines]
Luis
Click to expand...
Click to expand...
Alex tried your suggestion. It corrected the first problem regarding not
fouding MS Access. However, for some reason it does not like / runtime.

It still give me an error. Other suggestions, please.
Click to expand...

Jim's suggestion works only if you're not passing ANY parameters or command
line switches. Did you try Alex's suggestion? You do need the actual path to
the msaccess.exe executable (which might or might not be "C:\Program
Files\Office\msaccess.exe" depending on your version and how Access was
installed; you'll have to find the actual path to msaccess.exe).
 
You are correct but my intent is to use "runtime" to hide the code behind the
application. In order words I don't know anyone else to see the code. If you
have solution to this conodrum, please help..
Click to expand...

Why not give the user a .mde file (which does not contain the code)?
 
John said:
Why not give the user a .mde file (which does not contain the code)?
Click to expand...
I was not aware of that option. So what I need to do is save my mdi file as
mde, correct?

Thank you for patience and sharing knowledge.

Luis
 
I was not aware of that option. So what I need to do is save my mdi file as
mde, correct?
Click to expand...

mdi!!??

We ARE talking about Access databases here... right?

To save a mdb file as a mde, be sure it's completely compiled and has no VBA
compilation errors; you should also be sure that EVERY VBA routine has error
trapping code in it, since mde's will just crash and burn if you have
unhandled code errors. Then choose Tools... Database Utilities... Create MDE
file. This will take your existing .mdb file and save a copy as a .mde file,
with all the source code stripped out, and no ability to change the design of
forms, reports or other objects. You should keep a copy of the original mdb
file safe since you will need it to make any design changes.
 
Hi,
Try /runtime, not / runtime


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com


luis_a_roman via AccessMonster.com said:
Alex said:
Try to add a path to msaccess.exe:
"C:\program files\offoce\msaccess.exe"
"\\ftwdoors\JSFITCoord\acWKspace\F-35
Dash Board\Tactical DashBoard.mdb" / runtime
I set up a short cut in windows and specified the following information;
(1) In the short cut target I typed;
"\\ftwdoors\JSFITCoord\acWKspace\F-35
Click to expand...
[quoted text clipped - 14 lines]
Luis
Click to expand...
Click to expand...
Alex tried your suggestion. It corrected the first problem regarding not
fouding MS Access. However, for some reason it does not like / runtime.

It still give me an error. Other suggestions, please.
Click to expand...
 
John said:
mdi!!??

We ARE talking about Access databases here... right?

To save a mdb file as a mde, be sure it's completely compiled and has no VBA
compilation errors; you should also be sure that EVERY VBA routine has error
trapping code in it, since mde's will just crash and burn if you have
unhandled code errors. Then choose Tools... Database Utilities... Create MDE
file. This will take your existing .mdb file and save a copy as a .mde file,
with all the source code stripped out, and no ability to change the design of
forms, reports or other objects. You should keep a copy of the original mdb
file safe since you will need it to make any design changes.
Click to expand...
Thank you for all the guidance and collaboration. I"m ready to go.
 
Back
Top