Access Accde won't run any code at all

I am running Access 2007.  The accdb runs fine, but when converted to accde, none of the code runs, even basic code like DoCmd.Close.  Macros will run, but no event procedures. Code does compile just fine with no errors.  This is release 10 for this software, and all previous 9 released have converted and ran fine.

I tried importing all of the objects to a new database and recreating the accde, but still no luck.

I tried /decompile but it doesn't seem to run for some reason.


Appreciate any ideas.
mkwestAnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Does not run on any machine ?

Do you have any error trapping that would show errors that might be occurring ?

mx
hongjunCommented:
peter57rCommented:
Are you running the accde in a trusted folder ?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

mkwestAnalystAuthor Commented:
Does not run on any machine.  confession booth:  light on the error trapping, but all of the code runs fine in accdb during extensive use and testing.  but in Accde, even simple code docmd.close doesn't run.  if it was just one procedure that failed, I'd get it, but no code runs at all.

honqiun, I read the thread and tried the steps outlined.  Still no luck.
mkwestAnalystAuthor Commented:
Yes, trusted folder.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
And you have done a actual Decompile on the ACCDB ?

Don't suppose you can upload the ACCDB so we can create ACCDE ... for me it would be on A2010 ...

?
mkwestAnalystAuthor Commented:
How do I do an actual decompile?  I tried the run.../decompile but it didn't work.  
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:


first, if you have not already:
Open the VBA Editor and from the menu ...Tools>>References ....
If you see any listed as **Missing: <reference name>, including the asterisks and the word Missing, the
you need to fix that first.

Then, follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

AND ...
Once you get familiar with the Decompile idea (and ALWAYS make a BACKUP first!) ... you can add both Decompile and Compact/Repair to the Right Click menus in Windows Explorer, which I use multiple times daily:

Getting the Decompile and Compact context menu options
http://access.mvps.org/access/modules/mdl0039.htm

mx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mkwestAnalystAuthor Commented:
The 8 step solution provided worked great, directions were complete and easy to follow.  As suggested, I will do this on all of my databases and add it to routine maintenance.  Thanks for the speedy response time and solution...I never would have figured this out on my own.  You guys are lifesavers.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Seriously ?  Wow.  Long Live Decompile !!!!!!!!!!!!!!!!!!!!!!

I wonder WTH was actually hosed up ...

mx
mkwestAnalystAuthor Commented:
Seriously.  All hail decompile.  Tucking that one away for future reference.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Just always make a BACKUP first ....

mx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.