Results 1 to 10 of 10
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    1 user at a time (acc 2000)

    howdy friends,

    with my internship coming to an end it is fitting i need the forum for one last piece of help. We have created a database and placed in on the network dive to allow multiple users within the group to have access to it. there is a security issue because we only want 1 person at a time opening the database. if 2 users have the DB open at the same time huge problems could occur. is therre a way to limit the open privlege to only one at a time. i want to "lock" the file if it is already open. i have tried the exclusive seetting but it does nothing since the DB is on a local network drive on not on someones computer. we need 1 user access for a networkrd database, this has to be available. thanks for all the help.

    Ed the intern

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

    Re: 1 user at a time (acc 2000)

    It doesn't matter whether the database is on a local drive or on a network drive. If anyone opens the database exclusively (with the Exclusive setting checked), no one else can open it.

  3. #3
    New Lounger
    Join Date
    Jun 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 1 user at a time (acc 2000)

    thats exactly what i thought. i went uder tools > options >advanced and checked off exclusive. this was also done on th eother computer that would be opening the file. we can still both open the DB at the same time. is there another setting that needs to be in place? i feel as if we have missed a step somewhere. i followed the help instrcutions and yours but nothing is done. whether or not exclusive is checked the DB can be opened 2x. any suggestions or settings we also need in place to get tiss to work? thanks alot.

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

    Re: 1 user at a time (acc 2000)

    The Exclusive option only works from within Access - if it's set, the Exclusive checkbox will be on by default in the File/Open... dialog. It doesn't apply if you open the database from Windows Explorer.

    You can make a shortcut that opens the database exclusively. You'll have to instruct your users that they must always use this shortcut to open the database. Set the target of the shortcut to

    "C:Program FilesMicrosoft OfficeOfficeMSAccess.exe" "F:AccessMyDatabase.mdb" /excl

    Replace "C:Program FilesMicrosoft OfficeOfficeMSAccess.exe" by the exact path and filename of the Access executable.
    Replace "F:AccessMyDatabase.mdb" by the exact path and filename of your Access database.
    The /excl option instructs Access to open the database exclusively.

    HTH,
    Hans

  5. #5
    New Lounger
    Join Date
    Jun 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 1 user at a time (acc 2000)

    great hans!!!!! thats an awesome little tid bit. i never would have known it was an exploer issue and needed ot be done within access. my DB is finally perfect, never thought i could say that!!!!!!!!!!!!!!!!!!! thanks

  6. #6
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 1 user at a time (acc 2000)

    It sounds as though your problem is solved. There is another possibility whereby you would examine the .ldb file for that database to determine the number of users who have it open, in code, and not allow another instance to be opened if the number is above a threshold, in your case, one. This would eliminate relying on users to always use the shortcut you provide. If it's of interest to you, post back and I'll dig up the code.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  7. #7
    New Lounger
    Join Date
    Jun 2002
    Posts
    13
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 1 user at a time (acc 2000)

    the short cut does get the job done fine, but if it wasn't a hastle i'd liuke to see what that code would look like. its not a big deal im just a little curious of howw you would go about that. thanks a lot

  8. #8
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 1 user at a time (acc 2000)

    <img src=/S/hushmouth.gif border=0 alt=hushmouth width=16 height=16> Doh! I may have typed too soon. The function I referenced was authored by Susan Sales Harkin in the November 2000 issue of Inside MS Access, and, as such, is copyrighted. Her article details how to use an ADO schema recordset to fetch a list of users with a database open. My apologies! You might contact the nice folks at Element K Journals to ask about a single back issue purchase. Personally, I find the function invaluable.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

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

    Re: 1 user at a time (acc 2000)

    The article Shane is talking about may be copywritefd, in the MS KB you can find an article how to read a ldb file.
    See <A target="_blank" HREF="http://support.microsoft.com/default.aspx?scid=kb;EN;Q198755">Check Who Logged into Database with Jet UserRoster in Access 2000
    </A>With a little modification you can use the code to limit the access to your database to only 1 user.
    Francois

  10. #10
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 1 user at a time (acc 2000)

    Another thought is to set the drive so that it has no "Create" privileges then Access will only open exclusive <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
  •