Shortcut target path

[Guest]

I'm having a bit of trouble here with the shortcut. If I have to write the
target path, including "path to MSACCESS.EXE" I think I have a problem. I'm
not sure how to write it. my path to msaccess.exe is C:\Program
Files\Microsoft Office\OFFICE11

What comes next?

 

[Joan Wild]

I'm having a bit of trouble here with the shortcut. If I have to write the
target path, including "path to MSACCESS.EXE" I think I have a problem. I'm
not sure how to write it. my path to msaccess.exe is C:\Program
Files\Microsoft Office\OFFICE11

First, put it in quotes (because the path has a space in it)
"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

That's all on one line.

 

[Guest]

Okay, so here is what it would look like

C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe"
"\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb"
"\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdw"

I named my db the same as my mdw and I'm guessing that wasn't a good idea.
Does the target path look right?

 

[Joan Wild]

Change the name of the mdw. You can just change the file name in windows explorer, and then you only need to change the shortcut - it won't affect anything else.

Your target isn't quite right. You forgot the /wrkgrp switch. It should be

C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "\\essorgfs02\Proposal_Resources\CDRL Database\CDRL123.mdb" /wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\SomeNewName.mdw"

 

[Guest]

Okay, redid the path and I got a weird error. "The name 'C:\Program'
specified in the Target box is not valid. Make sure the path and file name
are correct.'

This is strange because the folder on the c drive is called 'Program Files'.
Why is it trying to recognize the wrong folder name? What am I missing? As
always, thanks so much for your help.

 

[Joan Wild]

You need to enclose each path in double quotes
"C:\Program Files\..."
Looks like I missed the initial double quote below.

--
Joan Wild
Microsoft Access MVP

Okay, redid the path and I got a weird error. "The name 'C:\Program'
specified in the Target box is not valid. Make sure the path and file name
are correct.'

This is strange because the folder on the c drive is called 'Program Files'.
Why is it trying to recognize the wrong folder name? What am I missing? As
always, thanks so much for your help.

 

[Guest]

OMG! It finally works!!!!! I thought this day would never come. I guess
now all I have to do is split it. For right now i only have 1 user. Do you
recomend splitting it now, or waiting until my beta testing with my one user
is over?

 

[Joan Wild]

I would split it now. Split it manually - don't use the splitter wizard, as that will leave the backend unsecured.

See www.jmwild.com/SplitSecure.htm for instructions.

Be sure to put the frontend on each person's computer (adjust their shortcut target to point to the location of the frontend mdb on their computer). You may (but not likely) have to modify the path to the msaccess.exe file if it differs on each machine. Put the mdw in the same location as the backend.

 

[Guest]

so if I split the DB and have the user save the front end on their C drive
the path would look like this?
"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "C:\CDRL123.mdb"
/wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\CDRLSecurity.mdw"

 

[Joan Wild]

Yes.

--
Joan Wild
Microsoft Access MVP

so if I split the DB and have the user save the front end on their C drive
the path would look like this?
"C:\Program Files\Microsoft Office\OFFICE11\msaccess.exe" "C:\CDRL123.mdb"
/wrkgrp "\\essorgfs02\Proposal_Resources\CDRL Database\CDRLSecurity.mdw"

 

[Guest]

Thank you so much for all your help Joan. It goes without saying, I couldn't
have done it without you.