Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    DAP Security (Access 2000 SR1)

    I am creating my first Data Access Page (DAP), in an existing MS Access database. The Access database has security with the .MDW residing on a shared network server. Rather than joining a workgroup (from WRKGADM.EXE), users invoke security from the specific .MDW via a switch in the target property of a shortcut ("C:Program FilesMicrosoft OfficeOfficeMSACCESS.EXE" "CataStore_SQLDataStore.mdb" /wrkgrp OnyxDataDataStore_FMDataStore_MDW.mdw /excl).

    When I open my new DAP in IE6, I am prompted for a Data Source Logon - name and password, similar to opening the Access .mdb file, itself. BUT my Logon name and password DO NOT WORK ("Not a valid account name or password.").

    Without forcing every user to join a workgroup, is there a way to invoke the security of a specified .MDW when opening a DAP?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DAP Security (Access 2000 SR1)

    Are you saying that the shortcut referencing the workgroup isn't working or how are you opening the DAP? Have you tried using UNC paths instead of mapped paths?
    Charlotte

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: DAP Security (Access 2000 SR1)

    I don't know enough about the web stuff (HTML, etc.). I will talk to our IT group for more hand-holding.

    But let me answer, and then ask a bit more. The shortcut opens the .MDB, invoking the security from the specified .MDW. I am opening the DAP (.htm) directly (through Windows Explorer, or within IE by the FileOpen dialog).
    Can I invoke the security .MDW in a UNC path? What's the basic syntax for that?

    (I won't ask for a lesson on all this web stuff. I know that this is not the appropriate place for that level of detail.)
    Thank you!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: DAP Security (Access 2000 SR1)

    The security should be built into the DAP already. The SystemDatabase property in the connection specifies the MDW and the login and password are in the connection properties as well.
    Charlotte

Posting Permissions

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