asked on

MDE file won't run in 2007

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.

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

peter57r

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?

PerksP

ASKER

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!

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"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