Results 1 to 5 of 5
  1. #1
    Cheshire101 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    42

    Question Security Help

    This may have been answered before but I can not find it anywhere.
    I have created a database with lots of SQL code underlying and I am trying to establish some security.



    I thought I would be able to create a front and backend database and set then change them over to MDE, but no go.

    When I try to change the frontend I get the error:
    "Microsoft Office Access was unable to create the .accde, .mde, or .ade file"

    Can someone help me with this?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It cannot work if there are any compile errors. Go to any code page <ALT>F11 and then Debug>Compile.

  3. #3
    Cheshire101 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    42
    Thank you so much... that worked. I had forgot an 'End IF' in a section that I had not completely tested..
    You are my hero

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Allan, you're a hero!! Apparently, you and Dustin Hoffman.

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That's great news! If you are good to go then go ahead and use the Thread Tools and mark this thread as Solved.

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

Similar Threads

  1. Security Advice
    By jpkeller55 in forum Access
    Replies: 6
    Last Post: 02-18-2011, 08:22 AM
  2. Security question
    By maxx3 in forum Security
    Replies: 2
    Last Post: 01-14-2010, 05:27 PM
  3. Security..Is there another way?
    By marianne in forum Security
    Replies: 0
    Last Post: 07-19-2009, 07:18 PM
  4. Database Security
    By marianne in forum Security
    Replies: 4
    Last Post: 06-15-2009, 07:12 PM
  5. User Security
    By Sanrv1f in forum Security
    Replies: 1
    Last Post: 06-03-2009, 01:36 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