Solved

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

Posted on 2012-04-08
7
611 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

622 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