Access 2010: .mdb works but .mde does not work
Posted on 2014-02-27
I have an Access application that still is maintain with access 2003, since it is used with 2003 and later access versions. Using 2010 something odd is happening: on some installations the .mdb (code version) works fine but the .mde version crash.
The background is the following: The .mde version is created on a WinXP PC with Access 2003. On the PC that cause the .mde to crash, Win 7 and Office 2010 with Access is used. The Macro-setting is enabled in the Trust center. The user has security properties for the folders as the following: Full control, Modify, Read & execute etc are all enabled. I only use Microsoft components like Common Controls 6.0, Script Host Object model, VBA ext 5.5 + the Excel, Word and Graph.
The question is why will .mdb runs fine while .mde crash? What is the difference? Could it be that a component is not updated (security reason)? Or is there any other Windows or Trust Center item that has to be changed?
Thanks in advance!