Solved

MDE file won't run in 2007

Posted on 2008-10-23
4
922 Views
Last Modified: 2010-04-21
We have just upgraded to MS Office 2007 using Windows XP.  

We have a master Access database which we distribute as an MDE files to all users.  I have, for the first time, made a change in the Master using 2007 and created an MDE file for distribution.  The MDEfile will open but nothing runs when a button is clicked to enter different areas of the database.  I have been checked the Trust Centre and enabled macros but this hasn't made any difference.  There are no security warnings when the file is opened so it is not even possible to enable content at opening

I have also converted the Master to 2007 in case that was the problem but it has not made any difference.  Any suggestions would be gratefully received as I'm currently left with the option of distributing the full version to keeo everyone working.
0
Comment
Question by:PerksP
  • 2
4 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 22787819
Before converting the MDB to the MDE, try running this procedure to be sure everything is in 'order' first.  You can probably ignore the part about References

A **DeCompile** may help here ...

But 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

mx
0
 
LVL 77

Expert Comment

by:peter57r
ID: 22787944
Which version have to moved from?
Are all users on A2007 now?

Are you saying that users Can run the mdb OK but not the corresponding mde?

0
 

Author Closing Comment

by:PerksP
ID: 31509285
Many thanks for such a quick response - I'm used to Access 2003 failing to create an MDE at all if there is a compile error so was thrown by the fact that the MDE appeared to be created without problems.  Everyone is happy again!
0
 
LVL 75
ID: 22788105
"Grade:  A - "Many thanks for such a quick response - I'm used to Access 2003 failing to create an MDE at all if there is a compile error so was thrown by the fact that the MDE  "

You are welcome.

mx
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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

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

1 Experts available now in Live!

Get 1:1 Help Now