Results 1 to 3 of 3
  1. #1
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328

    Prevent user from accessing design

    I am using Access 2007. I want to save the file giving the user no access to the design. I tried to save program as accde, but get message that it is too big-not sure why, it is not a huge file. I have done it with earlier versions, no problem.



    This is embarrassing, but I had some early versions that prevented users from accessing the design of an mdb file. I don't remember how I did it or maybe it has something to do with 2007 vs Access 2000? Any help much appreciated.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    I tried to save program as accde, but get message that it is too big
    implies there is an error in your code. To save as a .accde, the code must compile - ideally with 'Option Explicit' at the top of each module (below Option Compare Database) to reduce the risk of runtime errors once compiled. To compile, in the vba editor, select debug>compile

  3. #3
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    This may be a repeat-I clicked solved and my reply dissolved. The lousy code was part of a form that I don't use anymore and whose code I didn't erase properly.

    Just wanted to say thank you very much, problem was driving me nuts. Wonder why Access didn't give me a clear message like you did? Thanks again.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 12-28-2016, 11:39 AM
  2. Replies: 2
    Last Post: 10-24-2016, 02:20 PM
  3. Replies: 1
    Last Post: 08-14-2015, 12:01 PM
  4. Preventing user from accessing the Table
    By winsonlee in forum Access
    Replies: 4
    Last Post: 07-26-2011, 07:55 AM
  5. Replies: 2
    Last Post: 07-01-2010, 07:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums