Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Protect Access Database Source Code

    Hello,

    After developing an Access database, we want to publish it as an application so that the end users do not see the source code.

    How can this be done?

    TIA,

    BD.

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

    Re: Protect Access Database Source Code

    One possibility is to create an MDE file (Tools | Database Utilities | Make MDE File...). All source code is stripped from an MDE file, and the design of forms, reports and modules cannot be modified.
    Note 1: you can only create an MDE file from a database in 'native' format (Access 2002/2003); if you want to create an MDE from a database in Access 2000 format, you must convert it first.
    Note 2: keep a copy of the MDB file. If you ever want to change the design of a form, report or module, you must modify the MDB, then create a new MDE.

    Another possibility is to apply user-level security. See The secrets of Security on WendellB's website.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Protect Access Database Source Code

    Actually, as I've just found out, you CAN modify the design of a form or a report in an MDE database! You can't see the code, but you can open the form in design mode.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Protect Access Database Source Code

    Correct - this was discussed in the thread starting at <post#=417229>post 417229</post#>.

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Protect Access Database Source Code

    In addition to the suggestion from Hans and Mark, there are a couple of other options. First, you can apply a password to the VBA portion of your Access database - that of course is not terribly secure as there are numbers password cracking tools available. Second, you can create what is called a run-time version where the database cannot be opened to the database container window, and the user is not required to have Access installed. If you search the Access forum for runtime you should find numerous threads detailing the tools required as well as the issues associated with creating a commercial application.
    Wendell

Posting Permissions

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