Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access XP - Security (Office XP)

    Hi,
    Is there an easy effective way that I can secure a database that I am about to email to an associate. I want him to be able to open and use the database but not view or alter any of the structure. I am just a bit worried that some of my hard learned ideas (with many grateful thanks to the lounger support team) might be "borrowed" or worse - something critical might get deleted or altered. It is a fairly simple data entry database with a few forms, a couple of queries and a few reports. The machine it is going to is not networked, only one person would be using it and then emailing me back a text file of the data for further analysis.

    I would appreciate any advice.

    Thanks...Peter
    <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

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

    Re: Access XP - Security (Office XP)

    There are two alternative options:

    1) MDE

    Make an MDE file out of the MDB. In an MDE database, nobody can view or modify VBA code and the design of forms and reports. The design of tables and queries can still be viewd and modified.

    Note: If you are using Access 2002, this will only work if your database is in Access 2002 format. You can't make an MDE from a database in the default Access 2000 format.

    2) User-level security.

    By default, everyone logs in to an Access database as a user named Admin, without a password. In a new database, Admin has all permissions. It is possible to define other users and user groups with specific permissions. This involves creating a special workgroup file (MDW) that holds information about the users.

    If you remove the Admin user from the Admins group, and grant Admin only the minimum permissions necessary to work with the database, users who open the database the standard way will not be able to view or modify the design of database objects. If you log in to the database with a secured MDW file as a special user with full rights, you can change anything you need.

    Moderator <!profile=WendellB>WendellB<!/profile> has a short tutorial on his website (link in his profile, look for Support > Tutorials). It contains many useful links; the Security FAQ from Microsoft is a comprehensive overview of user-level security.

  3. #3
    Star Lounger
    Join Date
    Feb 2001
    Location
    New Zealand
    Posts
    63
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access XP - Security (Office XP)

    Once again, thanks for the help - that was exactly what I was looking for.
    Regards...Peter

Posting Permissions

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