Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Paths for Secured Database Shortcuts (Access XP)

    I always find creating the target paths for secured database shortcuts tedious. I have been creating them using a cut and past from the address bar and a Notepad text file that I save. I create 2 shortcuts for each database one to use for the network .mdw file for all users, and a second using a local .mdw file on my PC so if the network goes down I can still continue to do database work.

    The down side of using the address bar is it does not pick up the database .mdb name, just the path. If you open the run dialog box you can open any other folder and drag and drop an individual file into the run dialog box and get the full path, file name and the quotes as well. I don't know if this is something that has been already posted, or something that is already well known? I just recently learned this and have found it an easy way to get the full path, file name and the quotes.

    Carla

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Paths for Secured Database Shortcuts (Access XP)

    Hi Carla,

    If I remember correctly, this feature was introduced in Windows 95. I suspect that not many people know about it, so it's good to see this very handy tip posted, thanks!

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Paths for Secured Database Shortcuts (Access XP)

    We found from experience that if you have the option, it is nearly always better to put the security file on the local workstation. The security file is pretty much another Access database, and can be corrupted the same as .MDB files. It does create a deployment issue if you have frequent changes in the UserIDs, but we download a fresh copy from the server when necessary. The one downside is that users can't effectively change their own password. My <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15> on an interesting subject.
    Wendell

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paths for Secured Database Shortcuts (Access XP)

    One little utility I always install is RJHextensions. Right-click a file or folder in Explorer, and choose "Copy Path to Clipboard". Been using it so long and so often, that I forget it is an add-on utility. Highly recommended.

    http://www.rjhsoftware.com/downloads.html
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Paths for Secured Database Shortcuts (Access XP)

    NIce Utility, I downloaded and installed it works great!

    Carla

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •