Hi,
I have used the security wizard to set up basic security on my front end
database, and as part of it, it creates a shortcut on the desktop. I have
moved the shortcut to be in the same folder as the database and security
file, and want to amend the path variables so that they use relative path
names, but it doesnt seem to be working.
Any ideas?

The original string was:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "F:\Final Year
Project\DatabaseFrontEnd.mdb" /WRKGRP "F:\Final Year Project\Security.mdw"

And I changed it to:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
"DatabaseFrontEnd.mdb" /WRKGRP "Security.mdw"

Thanks

Unless the shortcut's "Start In" property is set to point to the correct
folder, Access has no way of knowing where to find the mdb and mdw files.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"torch_music" <(E-Mail Removed)> wrote in message
news:A43F19E7-3751-4299-8510-(E-Mail Removed)...
> Hi,
> I have used the security wizard to set up basic security on my front end
> database, and as part of it, it creates a shortcut on the desktop. I have
> moved the shortcut to be in the same folder as the database and security
> file, and want to amend the path variables so that they use relative path
> names, but it doesnt seem to be working.
> Any ideas?
>
> The original string was:
> "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "F:\Final Year
> Project\DatabaseFrontEnd.mdb" /WRKGRP "F:\Final Year Project\Security.mdw"
>
> And I changed it to:
> "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> "DatabaseFrontEnd.mdb" /WRKGRP "Security.mdw"
>
> Thanks

I have tried various combinations of . and .\ , both of which should indicate
the current directory, where all three files are located, but none of them
seem to work.
The most obvious one is to have the following
Start In: .
Target: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
".\DatabaseFrontEnd.mdb" /WRKGRP ".\Security.mdw"

But it returns the error message cannot find database file
".\DatabaseFrontEnd.mdb"

I cant see anything wrong with the syntax, is what I am trying to do just
not possible? Do you have to have completely hard coded paths?

Thanks
Peter

"Douglas J. Steele" wrote:

> Unless the shortcut's "Start In" property is set to point to the correct
> folder, Access has no way of knowing where to find the mdb and mdw files.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "torch_music" <(E-Mail Removed)> wrote in message
> news:A43F19E7-3751-4299-8510-(E-Mail Removed)...
> > Hi,
> > I have used the security wizard to set up basic security on my front end
> > database, and as part of it, it creates a shortcut on the desktop. I have
> > moved the shortcut to be in the same folder as the database and security
> > file, and want to amend the path variables so that they use relative path
> > names, but it doesnt seem to be working.
> > Any ideas?
> >
> > The original string was:
> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "F:\Final Year
> > Project\DatabaseFrontEnd.mdb" /WRKGRP "F:\Final Year Project\Security.mdw"
> >
> > And I changed it to:
> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> > "DatabaseFrontEnd.mdb" /WRKGRP "Security.mdw"
> >
> > Thanks
>
>
>

What you are trying to do is impossible. You can't use relative paths in a
shortcut.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"torch_music" <(E-Mail Removed)> wrote in message
news:CE07B3D6-C3B6-4D26-AA5B-(E-Mail Removed)...
>I have tried various combinations of . and .\ , both of which should
>indicate
> the current directory, where all three files are located, but none of them
> seem to work.
> The most obvious one is to have the following
> Start In: .
> Target: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> ".\DatabaseFrontEnd.mdb" /WRKGRP ".\Security.mdw"
>
> But it returns the error message cannot find database file
> ".\DatabaseFrontEnd.mdb"
>
> I cant see anything wrong with the syntax, is what I am trying to do just
> not possible? Do you have to have completely hard coded paths?
>
> Thanks
> Peter
>
> "Douglas J. Steele" wrote:
>
>> Unless the shortcut's "Start In" property is set to point to the correct
>> folder, Access has no way of knowing where to find the mdb and mdw files.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>>
>> "torch_music" <(E-Mail Removed)> wrote in message
>> news:A43F19E7-3751-4299-8510-(E-Mail Removed)...
>> > Hi,
>> > I have used the security wizard to set up basic security on my front
>> > end
>> > database, and as part of it, it creates a shortcut on the desktop. I
>> > have
>> > moved the shortcut to be in the same folder as the database and
>> > security
>> > file, and want to amend the path variables so that they use relative
>> > path
>> > names, but it doesnt seem to be working.
>> > Any ideas?
>> >
>> > The original string was:
>> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "F:\Final
>> > Year
>> > Project\DatabaseFrontEnd.mdb" /WRKGRP "F:\Final Year
>> > Project\Security.mdw"
>> >
>> > And I changed it to:
>> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
>> > "DatabaseFrontEnd.mdb" /WRKGRP "Security.mdw"
>> >
>> > Thanks
>>
>>
>>

Paul,
Pity, otherwise you need to edit the shortcut to correct the path depending
on where the user, or in this case my lecturer, puts the database. Never
mind, I'll just have to mention it in my final report.
Thanks for your reply.
Peter

"Paul Overway" wrote:

> What you are trying to do is impossible. You can't use relative paths in a
> shortcut.
>
> --
> Paul Overway
> Logico Solutions
> http://www.logico-solutions.com
>
>
> "torch_music" <(E-Mail Removed)> wrote in message
> news:CE07B3D6-C3B6-4D26-AA5B-(E-Mail Removed)...
> >I have tried various combinations of . and .\ , both of which should
> >indicate
> > the current directory, where all three files are located, but none of them
> > seem to work.
> > The most obvious one is to have the following
> > Start In: .
> > Target: "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> > ".\DatabaseFrontEnd.mdb" /WRKGRP ".\Security.mdw"
> >
> > But it returns the error message cannot find database file
> > ".\DatabaseFrontEnd.mdb"
> >
> > I cant see anything wrong with the syntax, is what I am trying to do just
> > not possible? Do you have to have completely hard coded paths?
> >
> > Thanks
> > Peter
> >
> > "Douglas J. Steele" wrote:
> >
> >> Unless the shortcut's "Start In" property is set to point to the correct
> >> folder, Access has no way of knowing where to find the mdb and mdw files.
> >>
> >> --
> >> Doug Steele, Microsoft Access MVP
> >> http://I.Am/DougSteele
> >> (no e-mails, please!)
> >>
> >>
> >>
> >> "torch_music" <(E-Mail Removed)> wrote in message
> >> news:A43F19E7-3751-4299-8510-(E-Mail Removed)...
> >> > Hi,
> >> > I have used the security wizard to set up basic security on my front
> >> > end
> >> > database, and as part of it, it creates a shortcut on the desktop. I
> >> > have
> >> > moved the shortcut to be in the same folder as the database and
> >> > security
> >> > file, and want to amend the path variables so that they use relative
> >> > path
> >> > names, but it doesnt seem to be working.
> >> > Any ideas?
> >> >
> >> > The original string was:
> >> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "F:\Final
> >> > Year
> >> > Project\DatabaseFrontEnd.mdb" /WRKGRP "F:\Final Year
> >> > Project\Security.mdw"
> >> >
> >> > And I changed it to:
> >> > "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE"
> >> > "DatabaseFrontEnd.mdb" /WRKGRP "Security.mdw"
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>
>