Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Join Date
    Mar 2004
    Posts
    660

    Unanswered: How to avoid user to change the design in Access front end

    I believe i asked this question before. I have a database sql server as backend and access as front end. But the thing is i don't want user who know a little bit access can change my design of the access front end. How could i do that? If user knows use control +shift, then he can change the design.

    Many thanks.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Most common is to distribute an MDE rather than an MDB.
    Paul

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Sometimes, you just have to beat your users into submission!
    Inspiration Through Fermentation

  4. #4
    Join Date
    Mar 2004
    Posts
    660
    I knew somebody told me this before. But how i can distribute to MDE. Can you give me reference?
    Thanks.

  5. #5
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Quote Originally Posted by yyu
    Can you give me reference?
    Sure...Access Help.
    Paul

  6. #6
    Join Date
    Oct 2006
    Posts
    110

    Cool

    Thanks for the good info.. I learn something new every time I come here..

  7. #7
    Join Date
    Nov 2005
    Posts
    113

  8. #8
    Join Date
    Mar 2004
    Posts
    660
    I check the help. I know how to make MDE file. On the Tools menu, click Database Utilities, and then click Make MDE File. But when i check mine, the MDE is not clickable. I can't click, What should i do?

    Thanks and Happy new year!

  9. #9
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    can you compile the code?
    Alt-F11 Debug/Compile
    ...if you have errors you need to fix them before making MDE

    are you in the correct version?
    e.g. if you are in Access-2003 it typically uses Access-2000 database format by default. so in the same menu where you found (or didn't find!) the Make MDE option, use Convert Database and convert to the actual version you are running. note that your application will no longer function in earlier versions of Access.

    izy
    currently using SS 2008R2

  10. #10
    Join Date
    Mar 2004
    Posts
    660
    I did convert to access 2002. Now i am able to On the Tools menu, click Database Utilities, and then click Make MDE File. But when i clikc the Make MDE File, it showed me that it can't make MDE file. What is wrong. The code has no problem.

    Thanks.

  11. #11
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    progress of a sort: at least the menu item is available.

    you claim The code has no problem but that is not a direct response to my question - does it COMPILE ?

    izy
    currently using SS 2008R2

  12. #12
    Join Date
    Dec 2006
    Posts
    53

  13. #13
    Join Date
    Mar 2004
    Posts
    660
    Thanks all. I knew. I have a compile error. I think that is the problem. Thanks again! Happy new year.

  14. #14
    Join Date
    Mar 2004
    Posts
    660
    I have compile error. I feel it is strange, As if i didn't make MDE database. It works fine. But when compile, it has error:

    Private Sub cmdClearAccepted_Click()
    'determine which to change to null
    If cmbAccepted = "Yes" Then
    DoCmd.OpenQuery "AcceptedYes"
    DoCmd.Close acQuery, "AcceptedYes"
    If cmbAccepted <> IsNull(Accepted) Then
    cmbAccepted = Null
    End If

    It said "cmdAccepted" variable is not defined. Actually it is a dropdown box named "cmdAccepted". How can i define this variable?

    Dim cmdAccepted as string???? I am not sure.

    Thanks.

  15. #15
    Join Date
    Dec 2006
    Posts
    53
    Code:
    Dim cmbAccepted As String
    cmbAccepted = FormName.cmbAccepted.Value
    Oh, and at the end, change to

    Code:
    FormName.cmbAccepted.Value = Null
    Last edited by dfwelch; 12-29-06 at 12:15.

Posting Permissions

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