Results 1 to 4 of 4

Thread: Code ? (97)

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Code ? (97)

    Without going into my reasons why, I would like to know if I can hide my code.

    I am putting together a small db. When delivered, I don't want the receiver to be able to view my code. I know I can select "HIDE" in the attibutes, but this isn't fool proof, most of us know how to unhide it. I want to protect it with a password or something in that nature.

    Even though it is a small db, the code that will run, has taken quite a while to put together, I don't want anyone to view, change, or copy it.

    Hope someone has an answer, Microsoft didn't.

    Thanks in advance.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

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

    Re: Code ? (97)

    I think you have to create a .mde file from your .mdb, and distribute the .mde file. (Tools menu, Database utilities; see Access Help.) Be sure to keep the original .mdb - you'll need it if you ever want to change something!
    Users can still view and modify table and query design, but can't view or modify the design of forms, reports and modules in a .mde file.
    (In Access 2000 and XP, you can protect a module with a password, but Access 97 doesn't have that option AFAIK).

    HTH, Hans

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Code ? (97)

    Yes! It

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

    Re: Code ? (97)

    There is another way without going to an MDE file (which is a pretty good solution - you just need to be sure to keep a development master around). If you implement security, and remove priviledges from the users but leave your own intact, you can block them from seeing the code modules, form designs and so on. It's a bit more bother than creating an MDE, but if you already have security active it is pretty painless. Hope your efforts go well.
    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
  •