Page 1 of 2 12 LastLast
Results 1 to 15 of 23

Thread: protection (2k)

  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    protection (2k)

    can i prevent the user from modify the from in mde case . i mean prevent him from see the disign of the form .
    Ashraf

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    In a MDE database the user cannot access the design view of a form, report, page, macro or module
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    hi Francois
    send me a form with mde and i try to send it modefi . ok
    Ashraf

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: protection (2k)

    You can create your own mde and you won't be able to modify the forms. That's why you have to keep a copy of the uncompiled mdb in order to make design changes to the mde interface objects or code.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    i do it already but there are some can to put them name in the forms in the mde case , so i want to prevent it .
    Ashraf

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

    Re: protection (2k)

    I think there is some kind of misunderstanding here. In an .mde database, users can enter and modify data in a form the same way they can in an .mdb database. But they cannot view or modify the design of the form or the code behind the form.

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    The mde will only prevent the user to modify the DESIGN of the form. Not the data. If you want to prevent they change data, you'll have to disable all the controls or use User Level Security.
    Francois

  8. #8
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    That is all ok , i will try with u . any one put mde file contain one form , ok i will try to return it modified .
    Ashraf

  9. #9
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    Here you have an MDE database. Can you modify the design or the code in form1 ?
    Francois

  10. #10
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    Hi ;
    HansV says : But they cannot view or modify the design of the form
    u say in the first : In a MDE database the user cannot access the design view of a form
    and iam not say that i can view the design of the CODE i say only the form .
    Ashraf

  11. #11
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    How did you do this ?
    Francois

  12. #12
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    160
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: protection (2k)

    first :
    iam ashraf khalil a member in arab team programing access , we do it 1 years ago and we try to protect it , so i ask here if any have a solve . u can do it by the steps .
    1- open ur mde file
    2- press alt + f11
    3- press at design buttom that u see it above .
    4- modifi what u want and save it .
    Ashraf khalil

  13. #13
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: protection (2k)

    On my machine, Alt+F11 brings up the Visual Base IDE, however the code is protected. There is no design button in the VB IDE and the design option is grayed out in the user interface in all menus. What are you seeing that is different? I opened the file in both 2000 and 2002 and got exactly the same behavior. There is NO way to edit a form in an MDE. The design menu is grayed out for forms and reports, although you are allowed to add/edit tables, queries and macros. You cannot edit any code container because there is no uncompiled code in an MDE.
    Charlotte

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

    Re: protection (2k)

    I'm afraid that Ashraf is right. I can reproduce it like this in Access 2002:

    - Create a database in Access 2002 format, or convert an existing database to Access 2002 format.
    - Create an .mde database from it.
    - Open a form in form view.
    - Switch to the VBE
    - Click the Design Mode button on the Standard toolbar.
    - If you're not switched back to Access automatically, press Alt+F11.
    - The form will be in design mode! <img src=/S/yikes.gif border=0 alt=yikes width=15 height=15>
    - You can view and edit the properties of controls.
    - You can't create new controls from the Toolbox (at least, I couldn't), but you can copy and paste or duplicate an existing control (I got an error message, but the control was still pasted/duplicated)
    - You can save the design of the form (you must do it explicitly, if you close the form before saving, you won't be prompted)
    - As far as I can tell, it is impossible to view or edit VBA code.

    This is horrible!

  15. #15
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: protection (2k)

    WOW -- this is new to me too!
    This should be kept secret from the general users!!!
    I wonder if this is a flaw in the program or if MS meant it that way! I cant believe it is meant as the tradition is to keep a mdb copy in a safe place!
    Regards,
    Rudi

Page 1 of 2 12 LastLast

Posting Permissions

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