First find the path to msaccess.exe on your machine (Start, Search, Files or
Folders and search for msaccess.exe). Make a note of the path to this file.
Right click on the desktop and choose, New, Shortcut.
In the next dialog click on Browse and navigate to msaccess.exe and Finish.
You'll see a shortcut on your desktop. Right-click on it and choose
properties; you'll see an item called Target with the path to msaccess.exe
in it. Now just edit this target by adding to the end of it
"path to the mdb" /wrkgrp "path to the secure.mdw"
--
Joan Wild
Microsoft Access MVP
"Len O." <(E-Mail Removed)> wrote in message
news:00bd01c3585e$bf812d70$(E-Mail Removed)...
> Honestly, I'm really not this incompetent.how do I go
> about creating a shortcut. Do I do it internally (access
> db\edit\create shortcut). If that's the case, I need to
> select a table/query/ etc.. for me to shortcut. What do I
> select?
>
> On the other hand, if I select the icon to shortcut, it
> doe not give me an option to customize a path. Rather,
> options given are desktop or duplicate copy.Please advise.
>
>
>
> >-----Original Message-----
> >Thanks Joan,
> >
> >I will give it a shot...
> >
> >if you're ever in D.C, dinner is on me!
> >
> >>-----Original Message-----
> >>Create a desktop shortcut for your secure database that
> >uses the /wrkgrp
> >>switch to point to the correct mdw.
> >>
> >>The target of the shortcut would look like
> >>"path to msaccess.exe" "path to mdb" /wrkgrp "path to
> mdw"
> >>
> >>--
> >>Joan Wild
> >>Microsoft Access MVP
> >>
> >>"Len O." <(E-Mail Removed)> wrote in message
> >>news:67ee01c35830$5418ece0$(E-Mail Removed)...
> >>> Thanks a Bunch Joan & Beth, your assistance is much
> >>> appreciated!
> >>>
> >>> Here's my problem...I can't use the security wizard b/c
> >>> i've already created a security access file for my db.
> >or
> >>> can I?
> >>>
> >>> another is, i have downloaded Access FAQ and it's
> >telling
> >>> me to move my mdw. file on to my network and join it
> to
> >my
> >>> access db. well, i was able to move my file but i can't
> >>> get it to join. the file is not being recognized by the
> >>> db. how do i join the mdw file to my access db?
> >>>
> >>> >-----Original Message-----
> >>> >A note on this: I found it FAR simpler to use the
> >>> >Security Wizard and follow the initial steps from the
> >>> help
> >>> >files verbatim. I tried to do it on my own and ran
> >into
> >>> >the same problems. However, with the security wizard
> >all
> >>> >is well...
> >>> >
> >>> >
> >>> >Beth G
> >>> >
> >>> >>-----Original Message-----
> >>> >>You need to download and study the Security FAQ
> >>> available
> >>> >at
> >>> >>http://support.microsoft.com/?kbid=207793
> >>> >>
> >>> >>If users are able to even open your database without
> >>> >using the workgroup
> >>> >>file you created, then you didn't secure it properly.
> >>> >>
> >>> >>Be sure to follow every step outlined in the FAQ or
> >your
> >>> >database won't be
> >>> >>secure.
> >>> >>
> >>> >>
> >>> >>--
> >>> >>Joan Wild
> >>> >>Microsoft Access MVP
> >>> >>
> >>> >>"Len O." <(E-Mail Removed)> wrote in message
> >>> >>news:02b101c356c9$331fc080$(E-Mail Removed)...
> >>> >>> Why is my security access (user/workgroups) only
> >>> >>> applicable to my pc? When other workstations
> access
> >>> my
> >>> >MS
> >>> >>> Access DB on the network, the security privileges
> >I've
> >>> >>> implemented is not recognized by their workstation.
> >>> How
> >>> >>> can I best set-up security for an Access db on the
> >NT
> >>> >that
> >>> >>> would enable all users to log-on with the username
> >and
> >>> >>> password assigned to them????
> >>> >>
> >>> >>
> >>> >>.
> >>> >>
> >>> >.
> >>> >
> >>
> >>
> >>.
> >>
> >.
> >
Similar Threads
