Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

finalizing a database

Discussion in 'Information Technology' started by Greg, Nov 18, 2005.

  1. Greg

    Expand Collapse

    hello. i want to first say that i welcome anyone's ideas for this post.
    please feel free to throw your 2 cents in.

    i have a db that i'm finishing that i'm going to be giving to others to use.
    the ONLY thing they're going to need to manipulate in this db are 3 forms and
    1 simple table (1 field which is a list of names). what is the best way to
    secure or lock these items, as well as the other 6 or so tables, queries and
    reports that i don't want them to open, change or delete. also, what
    'finishing' changes should be made to polish the forms for presentation?
    this can be for the items or access as a whole.

    i don't know if you need to know this but there is some vba that opens and
    closes various forms and reports when they're using any of the 3 forms. i,
    of course, still need this to happen.

    i'm looking for suggestions ranging from adjusting the whole item (query,
    form, whatever) to adjusting properties on an object in the item that need to
    be set. just please keep in mind that i'm not proficient with access as a
    whole or vba almost at all so please be very specific in your answers.

    think of this as a 'best practices' post so i really do welcome any
    suggestion, no matter how small it seems.

    Thank you very much in advance for your advice.
  2. Loading...

    Similar Threads Forum Date
    USA NSA has massive database of Americans' phone calls (USA Today 5.11.2006) Breaking News Jun 11, 2013
    Some database errors while navigating SPN forums Announcements Dec 29, 2004

  3. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse

    You most certainly can, and should hide all of the ms-access interface. The
    options to complete hide and keep people out of the ms-access interface can
    easily be done using the tools->start-up options. Using those options allows
    you to complete hide the ms-access interface (tool bars, database window
    etc). Also, using these options means you do not have to bother setting up

    Try downloading and running the 3rd example at my following web site that
    shows a hidden ms-access interface, and NO CODE is required to do
    this....but just some settings in the start-up.

    Check out:


    After you try the application, you can exit, and then re-load the
    application, but hold down the shift key to by-pass the start-up options. If
    want, you can even disable the shift key by pass. I have a sample mdb file
    that will let you "set" the shift key bypass on any application you want.
    You can get this at:


    And, some nice tips on building a ms-access interface (with some screen
    shots can be seen here)


    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
  4. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse

Share This Page