Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    User Access (Access)

    I created a database and it is saved on our shared drive. Currently if someone is in the database no one else can access it. Eventually, I need to place the database on our intranet portal. On the portal I want people to be able to open and view the database, but not be able to make any changes.

    How do I modify my database so that more than one user can be in the database at the same time when it is on the portal and also on the shared drive. The database on the shared drive I want people to be able to make changes to the data.

    I did not set up any user names or passwords.

    Thanks for your help.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Access (Access)

    For user level security, check out WendellB's tutorial here. As far as multiple users, you'll need to split your database. You can use the built-in database splitter, just make sure you make a copy of your database before you use the wizard.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

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

    Re: User Access (Access)

    In addition to the comments by <!profile=NYIntensity>NYIntensity<!/profile>, if you are going to make your database visible to Internet users, you will need to provide some sort of Web-based viewer. There are several options, such as ASP, PhP, and DAPs (if you are using 2002 or 2003) - each have their pros and cons.

    It is also likely that you or someone else is opening the database in exclusive mode - or that you have a form or report open in design mode. You don't indicate what version you are using, but 2000, 2002 and 2003 all put the database in exclusive mode once an object is opened in design mode. Adding Access User Security to your database won't help that problem. For that issue, we split the database and put a copy on each user's workstation.
    Wendell

  4. #4
    Star Lounger
    Join Date
    Jun 2005
    Location
    Delaware
    Posts
    79
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Access (Access)

    I am using Microsoft 2000. I have split the database as suggested and have hidden the tables, queries, and reports in the front end of the database. The front end is what will be used on the shared drive.

    I have attempted to open the shared drive while it is currently open on another computer and it still will not open for the second user.

    You stated that the database is open in exclusive mode once an object is opened in design mode. I'm not sure what you mean by this.

    I have only been using Access for about 5 months and have mainly been learning by "fire" <img src=/S/fire.gif border=0 alt=fire width=15 height=15> . So forgive me if my statements are on the "dummy" side and a beginner should know the answer.

    Thanks for your help.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User Access (Access)

    >>I have attempted to open the shared drive while it is currently open on another computer and it still will not open for the second user.

    Are you saying the drive won't open, or the front end file? The best way to use a FE/BE split design is to distribute the front end onto user computers. Establish the link to the tables in the back end on the shared drive, and then copy and paste the front end file onto individual desktops (or C: drives, etc...). Make sure when you create this link that if the back end is on your local machine you still go through the steps of finding the database through the network, otherwise you'll be creating a link to a local drive, and when you deploy the front end, it will search for a back end on the local machine, instead of across the network.

    >>You stated that the database is open in exclusive mode once an object is opened in design mode. I'm not sure what you mean by this.

    He meant that if you're editing a database object (a form's design, a query, a table's fields, etc), your database will automatically be changed to 'Exclusive'. The best way to keep front end users out of this is to create custom menu bars, and hide the database window, through one of the options given in <post#=532,757>post 532,757</post#> .
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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