Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security on other computers (2000)

    So I got my application to work exactly as I wanted it to work -- on my computer. I put it on our network and was unable to open it from another computer. So I modified the "user" permissions (but did not give the users Admin access on everything) and could open the file on other computers, but it didn't prompt me for a password on these other computers (which is crucial in this application).

    This may or may not be related, but I think I made a mistake and didn't rename the "secured.mdw" file on my computer. I am now prompted for a username and password anytime I open Access, which is kind of annoying.

    So, basically, I need to know how to set up my access application on other computers such that it prompts them for their userID and password. Do I need to set the user to Admin on the network copy and then secure each application at the desktop level? Is there any easier way to do this?

    Thanks,
    Kindra

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

    Re: Security on other computers (2000)

    On your own PC, you should join the default unsecured workgroup file System.mdw again, so that you don't have to provide user name and password when you open Access.

    Create a shortcut that opens your secured database together with the secured workgroup file. The target of the shortcut should look like

    "C:Program FilesMicrosoft OfficeOfficeMsAccess.exe" "F:AccessMyDatabase.mdb" /wrkgrp "F:AccessSecured.mdw"

    Of course, you must substitute the appropriate paths and file names. Make the shortcut available to the users. If they use it, they will be prompted for a user name and password; if they don't, they will log in as Admin automatically and have only limited rights.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2003
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security on other computers (2000)

    <hr>On your own PC, you should join the default unsecured workgroup file System.mdw again, so that you don't have to provide user name and password when you open Access.<hr>
    How do I join the System.mdw? Just go through the User-level security wizard again? What should I do differently?

    For the shortcut target on other PC's, just so that I'm clear:

    "C:Program FilesMicrosoft OfficeOfficeMsAccess.exe" -- Location of the Access program
    "F:AccessMyDatabase.mdb" -- Location of the database on the network
    /wrkgrp "F:AccessSecured.mdw" -- Location of the workgroup info file on the network

    Is that right?

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

    Re: Security on other computers (2000)

    To join a workgroup, you must use the Workgroup Administrator program Wrkgadm.exe. The default location for it in the US English version is C:Program FilesMicrosoft OfficeOffice1033.

    Your assumptions about the parts of the target for the shortcut are correct. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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