Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2014
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    security of database

    Dear All
    Has a database project and became a project ready, but how the program can be protected in a way you can not manipulate it, delete, or export tables or queries ..

  2. #2
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    275
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can compile your database into an mde file which will make it a runtime file only. In a mde database the user has no access to design view for any of the database objects. Any changes have to be made in the original mdb file and then converted again. However, though tables cannot be exported from a mde file you can still link to the tables from another database and you may be able to import them too.
    Thanks
    chuck

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,514
    Thanks
    3
    Thanked 48 Times in 48 Posts
    Adding to Chuck's comments, I presume when you mention project that you are not referring to an Access ADP project that uses a SQL Server back-end, but are working with either a .mdb file or a .accdb file. Forms and reports (and any VBA code) cannot be opened in design mode, but tables, queries and macros can be viewed and modified. If you are working with a .mdb format Access database, then there is the option to use Access User Security which gives fairly good control over who can do what to each object in the database. The tutorial The Secrets of Security, while somewhat dated, might get you started on the topic, and a search turns up numerous other tutorials and videos on the subject. Note however, that the .accdb format introduced in Access 2007 does not support that feature. You might also want to look at Introduction to Access 2010 security.
    Wendell

  4. #4
    New Lounger
    Join Date
    Feb 2014
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    very very thank you all

Posting Permissions

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