Results 1 to 14 of 14
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to get multi user access from single user lice (97)

    how to get multi user access from single user license
    my I.T. dept told me today that the company only supports single user licenses for access97 & I just developed a database to be shared throughout our regions & found that if one person is in it, nobody else can get in. Basically my front end is an .mde with links to a back end .mdb & it is the back end that is complaining that one person cannot access while another is in it. Any suggestion on how to get out of this dilly of a pickle?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    Licences have nothing to do with multi user.
    Licences determines the quantities of installations of the program you buy.
    Access is always multi user.
    Check in Tools | Options, Advanced Tab if the Exclusive option is checked in Default Open Mode. If so check Shared to allow Multi user.

    Francois
    Francois

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    Francois,
    I made a new copy of my .mde & verified that the .mde had the settings you specified. I also verified that similar settings were in my backend .mdb my .mde had links to. The error still came up. The ONLY thing I can imagine is that my I.T. did something b/c I sent them a list of user permissions on the .mde & .mdb files. For everyone but myself I told I.T. to set access to the .mde as read only & only I have access to the .mdb, could that mean something?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    Arage,

    I don't know very much about Networking and Permissions <img src=/S/sad.gif border=0 alt=sad width=15 height=15>.
    Anyway, I don't think it is a good idee to give read only permissions to your users.
    What does Access when it have to write tempory tables or other stuff. I don't know. Perhaps your IT can tell you more about that.
    If you want to secure your mdb's and mde's, try with User Security.
    It is more flexible and you are the one who grant permissions and not your IT.
    A good start to the User Security is :
    <A target="_blank" HREF=http://support.microsoft.com/support/access/content/secfaq.asp>http://support.microsoft.com/support/acces...tent/secfaq.asp</A>

    Francois
    Francois

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

    Re: how to get multi user access from single user lice (97)

    <hr>For everyone but myself I told I.T. to set access to the .mde as read only <hr>
    That's the reason you're running into problems. When you open a database on a server (or anywhere else, for that matter), Access opens an LDB file. Every additional user who logs into a database on a server has his lock information added to the existing LDB file. Unless your users have read/write permissions, they can't write their locks to the LDB file and so they can't get in.
    Charlotte

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: how to get multi user access from single user lice (97)

    As Charlotte mentioned, you need to give everyone who uses the database full permissions to the network directory containing the backend database. This includes Delete permissions, because the last one out of the database deletes the .ldb file.

    Don't make the .mde read-only. Access writes to that database itself. And the users can't modify anything anyway, since it is a .mde file.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    Hi Mark,
    Listen to what you

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

    Re: how to get multi user access from single user lice (97)

    I'm sorry, but you misunderstood me. Users must have permissions to the backend as well as the front end. An ldb file is opened on *each* database, frontend, backend, library database, all of them.
    Charlotte

  9. #9
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: how to get multi user access from single user lice (97)

    >>Listen to what you
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  10. #10
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    we

  11. #11
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    Arage,

    User security will not preventing to delete the file from in Explorer. It is only to grant different level of permissions to each object in the database.
    Yes the permissions are transfer from your mdb to your mde file.
    For your back-end you'll have to secure it like your front-end.
    For your 2 groups, you'll have to give appropriate level of permission for each object (Database, tables, queries, form, reports, macros and module) in your databases (front and back-end)
    Don't forget to make backup of your files before beginning with security. The first time you use security, it is very easy to make mistakes (later also <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>).

    Francois
    Francois

  12. #12
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: how to get multi user access from single user lice (97)

    Unfortunately, my security skills aren't too great. I'd suggest you follow the Compuserve link below to get to the MSDEVAPPS forum, which includes Access (as well as VB, FoxPro, SQL server, etc.). There are 2 files in the forum libraries that will help you:

    SECFAQ97.ZIP is a security FAQ, co-authored by Paul Litwin.
    SECURE70.EXE is a security whitepaper (also on MS site).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  13. #13
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    tell me this Francois, when I secure my backend, does that mean I

  14. #14
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: how to get multi user access from single user lice (97)

    Arage,

    No, you do not need to create a new workgroup file.
    With wrkgadm, join the workgroup you create for your front-end.
    Then, start Access and open your back-end with your login (not admin) and run the security wizard.
    In the first screen of the security wizard, look at the last two lines which give the username and the workgroup file. If they are OK then proceed with the wizard.

    Francois
    Francois

Posting Permissions

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