Consulting

Results 1 to 6 of 6

Thread: .ACCDE file

  1. #1

    .ACCDE file

    I've been trying to save a Access application as .accde file to block the code to user. But no luck all, always get error msg.

    Is there any way to block the code to user in Access 2007?

    Thanks in advance.

  2. #2
    VBAX Master CreganTur's Avatar
    Joined
    Jan 2008
    Location
    Greensboro, NC
    Posts
    1,676
    Location
    Are you talking about setting a code password? This requires a password to view any code modules. In the VBE click Tools -> Properties(will say Project Properties, where project is your project's name) -> Click the protection Tab -> Lock Project for Viewing -> set a password -> click Ok.
    -Randy Shea
    I'm a programmer, but I'm also pro-grammar!
    If your issue is resolved, please use Thread Tools to mark your thread as Solved!

    PODA (Professional Office Developers Association) | Certifiable | MOS: Access 2003


  3. #3
    VBAX Regular Apps's Avatar
    Joined
    May 2006
    Posts
    38
    Location
    Hi dhartford - please could you let us know what steps you are currently trying to do to save it as a .accde file?

    -thanks

  4. #4
    Just ender VBA and perform the Compile operation. Fix all the errors in the VBA code and then try again to make the ACCDE file.

  5. #5
    VBAX Mentor Movian's Avatar
    Joined
    Aug 2008
    Location
    NC, USA
    Posts
    399
    i find that most of the time when i can't compile to an accde file that there is an issue with broken references. I normally go to the references, deselect all of the additional ones, then reselect then and do a compact and repair and it will then let me compile the database.

    hope that helps

  6. #6
    VBAX Expert Imdabaum's Avatar
    Joined
    Jun 2006
    Posts
    652
    Location
    That helped out quite a bit. I just assumed that the person who created this database had already compiled it. How wrong I was..

    Love this forum and the great answers I find.
    Someday I'll understand everything...
    Even then...I'll still pretend I'm a beginner.

Posting Permissions

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