Solved

(Another) "unable to create accde" in Access 2007

Posted on 2012-04-08
7
588 Views
Last Modified: 2012-04-09
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27625383.html

Greetings all ...

I can't seem to get around the failure to create an ACCDE file. I've run through the steps outlined in the above link's question 4 times, and feel I'm doing everything to the letter.

This is a huge conversion for a project I've had available for years, but only as a linked ACCDB FE/BE pairing. It's important enough that I be able to create these ACCDE files that I'm trying to make sure these larger functions will work before I invest another 30 or 40 hours in development time.

There are about 25 linked tables (no data, just structure), and 2 forms. I have a reference out to a Lib Db, existing in the same folder as the file I'm trying to convert. I'm trying to convert it into the same folder as the source ACCDB file.

The only thing I can think of that's weird is that I made the mistake of letting the wizards create the 5 command buttons on one of the forms, before realizing that it creates those little embedded macros. Each of my command buttons has ancillary behaviors built in, so I went in and "replaced" (I think ... I don't know how to delete these little macros)  the Click event reference with a regular section of code in the class module. I've compiled, repaired, decompiled , recompiled, repaired, compiled, decompiled and repaired so many time now that I can't imagine there are still vestiges of those original little embedded macros, but what do I know?

All I know is that Access is throwing up the "Unable to create Accde" dialog box almost as fast as I select a location for the file, and I can't get beyond it. And I need to know if this whole conversion to an accde will be an unachievable goal before I get to much further.

I understand this question has been covered before, but let's just call this a "Hail Mary".

Many thanks in advance for any suggestions as to what I might look for (in addition what MX covered in the above link)

All best,

John
0
Comment
Question by:jofoco4
  • 4
  • 3
7 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 37822176
just  to isolate where the problem is coming from and to clear your doubts about the 5 command buttons that you created using the wizard...
create a copy of the db..
1. in the copy, delete the form with the 5 command buttons ( yes delete the form)
2. Now hit Alt + F11 to open the VBA window
     a. do a DEBUG >Compile
         make sure that the compiling have no errors raised, ( if there are any errors, correct them)
3. Do a compact and repair

4 Now try to make an .ACCDE file
0
 

Author Comment

by:jofoco4
ID: 37822309
Thanks. Reasonable approach.

I deleted links to all the tables except one (still no data, just structure), deleted all the forms, (which presumably eliminated the class modules), eliminated all the code from the Main module (but left the module itself in place, with the single Option Explicit line), and eliminated all the macros. I then compiled, exited, restarted, repaired, exited, restarted, decompiled, exited, restarted, repaired again, exited, restarted and compiled again (didn't need to this time, because the Compile option was greyed out). The system threw up the dialog box indicating it failed to create the ACCDE file as soon as I hit the enter key after selecting a file location (No real surprise this time on the speed of the dialog box feedback, given that there was nothing left in the file to convert in the first place...)

So I'm unable to convert a file with nothing in it but a good link to an empty table and a module with a single line.

Thanks for your feedback, my friend. But clearly I am not meant to be able to convert this app to an accde file.

And yes, I know I know I know. Next, I'll cold boot my workstation 5 or 6 times and then create a brand new file, just for this exercise. I won't set any external references, or create any forms, macros, queries or tables. I'll create a single module, with the two words "Option Explicit". And I'll see what happens when I try to convert that file. If it works, I'll begin adding objects back in, one at a time, attempting to reconvert into a new ACCDE file after creating each command button and after saving each new line of code, until it fails and tells me where it hurts.

Sheesh. We'll see what happens.

Please excuse my not well hidden frustration. I do very much appreciate your response. I'll post a followup note in a day or so to document the results.

Thanks again, and all best.

John
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 37822323
ok, but before you proceed make sure you have the latest service pack (SP3) for office 2007

To find what SP you have
Office Button > Access Options > Resources

Look in the About section


http://www.microsoft.com/download/en/details.aspx?id=27838
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:jofoco4
ID: 37822326
OK. That didn't take long.

I can't convert a file with a VBA reference to an external database. There are no module calls, no objects to speak of in either file. Just the mere existence of a reference to an external database seems to be what's ticking off the poor little delinquent.

Certainly changes the nature of my question.

Do you know if that means that option is off the table for good?

I'll noodle with the few approaches, and will probably rephrase a new question tomorrow, given that we can narrow down the problem somewhat.

Thanks again for your help in nudging me into "experiment and error trap" mode. The more I work with Access the more it seems I really should always be ready to adopt that approach.

Best,

John
0
 

Author Comment

by:jofoco4
ID: 37822329
And yes, I do have SP3 installed. Release 12.0.6606...

John
0
 

Author Closing Comment

by:jofoco4
ID: 37823214
The points are yours for responding, my friend.

On the bright side, your recommendation (to remove certain objects and try again) did lead me to the further revelation regarding the external reference, and the revised question.

All best...

John
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 37823610
John,
sorry, i was not able to post back yesterday got very busy..(easter sunday)
anyway, i saw that you posted another q regarding external library.. and i will leave it to jdetmann to sort this out for you (you are in good hands)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

943 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now