Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Thanked 0 Times in 0 Posts

    Forbid design view (Access 2000)

    I want to make my forms and reports unavailale to the user to be opened in design view.Is it posible ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Forbid design view (Access 2000)

    One possibility is to create an MDE file from your MDB (Tools | Database Utilities | Make MDE File...) In an MDE file, the design of forms, reports and modules cannot be seen or altered. It is still possible to edit the design of tables and queries. You *must* keep a copy of the MDB file, for if you ever need to modify the design of a form etc., you must do so in the MDB, then convert to MDE again.

    Another possibility is to apply user-level security. You can define users with different "roles" - designer, end-user, etc. Moderator <!profile=WendellB>WendellB<!/profile> has a short tutorial on security on his website, with lots of useful links; his profile contains a link (look for Support > Tutorials.)

    If you want to keep it very simple, but not really secure, just set the startup options (Tools | Startup...) to hide the database window, not display the full menus and toolbars etc. You (and others) can get around this by holding Shift down when opening the database.

Posting Permissions

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