Results 1 to 6 of 6
  1. #1
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591

    Publishing as ACCDE Question 2 - Will Not Compile

    I've thought this over and changed my mind since question 2 seems distinctly different. My other Front End, not just a copy, but an entirely different form, queries, reports and modules will not compile.

    "Microsoft Access was unable to create the .accde, .mde or .ade file."

    Help gives me a warning about creating too many tables, forms, reports and/or modules, but that is not my problem. There are less than 100 altogether. This Front End is similar to the other in that it is also primarily macro driven. I've encountered this before when my code put some reports into design mode and changed the record Source, but that is not happening here. There are two forms and two modules and I have touched only a small portion of it. This is the same problem the back end is having. The Back End is similarly straightforward. There is very little to it, a single form, a couple command buttons and a couple modules. Tips and a shove in the right direction would be appreciated. Let me know if you have any questions.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    have you

    a) set option explicit at the top of each module
    b) compiled the code from the vba editor

    if not, do it - the reason you cannot make an accde is because you have undeclared variables or other code which will not compile - a requirement to create an accde

    Once done, and you have resolved any compilation issues you should be able to create your accde

  3. #3
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    Ajax, I will keep that in mind for future reference. The point has become moot as these databases will not be compiled.

    Thanks again,

    Paul

  4. #4
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Just a question, Paul -

    You said the databases will not be compiled - do you mean by that that they won't be used? A database that won't compile (i.e. has code errors) cannot be used safely. Compilation errors should always be fixed, whether or not you want to make an .addce file.

  5. #5
    Paul H's Avatar
    Paul H is offline Expert
    Windows XP Access 2010 32bit
    Join Date
    Sep 2011
    Location
    Richmond, VA
    Posts
    591
    I mean they have been in use for a dozen years without being compiled and my client (I am a contractor) doesn't want them compiled. I'd be glad to spend my time and their money debugging them if they ask me to.

  6. #6
    John_G is offline VIP
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    The client doesn't want them compiled??? What an odd arrangement. I think the client's definition of compiling is not the same as yours or mine - compiling is not the process of creating an .mde or .accde - it's part of the process of checking code for errors.

    Oh well - it's their money - they get only what they want, I guess.

    Cheers!

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

Similar Threads

  1. Publishing as ACCDE Questions
    By Paul H in forum Access
    Replies: 3
    Last Post: 04-05-2016, 07:26 AM
  2. Publishing a database on my webpage
    By DONCOR in forum Import/Export Data
    Replies: 5
    Last Post: 08-29-2014, 09:29 AM
  3. Replies: 1
    Last Post: 02-01-2013, 06:08 PM
  4. Question on making an accde
    By itm in forum Access
    Replies: 4
    Last Post: 10-24-2012, 10:43 AM
  5. Publishing Project
    By MAABDOLAT in forum Access
    Replies: 1
    Last Post: 06-11-2010, 07:53 AM

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