Results 1 to 10 of 10
  1. #1
    Join Date
    Apr 2004
    Posts
    77

    Smile Unanswered: How to hide tables and the rest form users!

    Hi there

    I need to put my db on the network so that users can begin to use it, however I was wandering how can I get to prevent users from viewing the tables, queries, macros, modules etc

    Also how to prevent the users from having access to design view. Basically how to prevent them from messing with the develpoment stuff.

    basically I think the frontend stuff should be different from the backend? how do I separate them.

    Many Thanks for ur help in advance.

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    There is a wizard that will do that for you....
    Ryan
    My Blog

  3. #3
    Join Date
    Jul 2004
    Posts
    30
    Tools>Security>

  4. #4
    Join Date
    Apr 2004
    Posts
    77

    re: how to hide tables and rest from users

    Many Thanks guys for ur reply.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    You can hide the DB Window by changing the property StartupShowDBWindow Just have a look to that property. You have to disable the SpecialKeys through AllowSpecialKeys Have a look to that too.

  6. #6
    Join Date
    Apr 2004
    Posts
    77
    thanks Hammbaka for ur reply. Would do that

    Many Thanks

  7. #7
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Smile

    Or simply convert your database from MDB to an MDE file, that way your CODE, Design features and all are not available. Also, you can Split your database as well. Then too, make all your tables System files and set their values to Hidden.

    so many ways to do one thing....hmmmm,

    have a nice one,
    Bud

  8. #8
    Join Date
    Jan 2004
    Location
    Vancouver, WA
    Posts
    41
    Just be sure to remember that an MDE is not updatable -- you will not have access to any of your code. Creating the MDE is the final step for releasing.

    Perhaps you already know this, too, but if you add a macro named "AutoExec," the database will execute this upon launch. Set this macro to execute a module procedure, and you can use this procedure to set the various flags. Here is a list of some that you may want to research and include in such a procedure:

    StartupShowDBWindow
    AllowBuiltinToolbars
    AllowFullMenus
    AllowBreakIntoCode
    AllowSpecialKeys
    AllowShortcutMenus
    AllowToolbarChanges
    AllowBypassKey

    Setting all of these to False will prevent users from accessing any non-interface parts of the app. Just be sure that you do NOT set this in your MDB, or you'll be one unhappy camper. So add a series of safety "confirmation" dialogs before setting the above items, just to insure that you never set them in your MDB.

  9. #9
    Join Date
    Apr 2004
    Posts
    77

    How to hide tables from users.

    Thanks Bud and Mtnorwood for ur help


    many thanks

  10. #10
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by caprideveloper
    Thanks Bud and Mtnorwood for ur help


    many thanks
    Anytime, that's what we're all here for and that's what makes it nice.

    laterz
    Bud

Posting Permissions

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