Changing the path in security shortcut



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"


Douglas J. Steele

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.


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

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?


Paul Overway

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


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question