Why can't Access 2007 open the MDE file?

[jonathanchye]

I've created a normal MDB file which I can open in Access 2007 just fine.

However, when I use Access 2010 (on my dev PC) to convert that MDB file into an MDE file I can't open it in Access 2007... should I use Access2007 to convert the mdb file instead?

 

[jonathanchye]

Right, I've used Access2007 to convert to ACCDE this time but it crashes everytime I open the ACCDE file... any ideas?

 

[SteveH2508]

Have you compiled the file without errors before making the mde?

Have you got Option Explicit at the top of ALL of your modules?

 

[jonathanchye]

Have you compiled the file without errors before making the mde?

Have you got Option Explicit at the top of ALL of your modules?

Haven't checked compile errors. Thanks for reminding me.

 

[jonathanchye]

Well I've debugged the code without any errors and have used Option Explicit instead of Option Compare Database but it still crashes. I think it has something to do with VBE.DLL conflict.

Could this be caused by MS Office 2007 not being updated to latest service pack?

 

[thechazm]

MDE files that are compiled on newer versions of Access will not run on older versions. Like in my case I have 2007 loaded on my computer that I develop on. Most of the computers are 2007 but some are 2003 so the only way I can make an mde work on both is to take my mdb to a computer that has 2003 loaded on it. Compile the code to look for compatability issue's. Finally making the mde with the 2003 office program.

Then this works on both 2003 and 2007. Should be the same concept between 2007 and 2010. Do not have these installed together on the same machine and try it though. Seems like tons of problems happen after that.

I did find a few ways to make the double install to work seemingly ok but I would aviod it if possible.

Hope this helps,

TheChazm

 

[boblarson]

Office 2007 and 2010 should not be installed together. And also, because you have some incompatible features in 2010, compiling in 2007 causes you the problems. How do I know that you have incompatible features? Because when I opened your file in 2007 I get a yellow warning right above the spot where I click the Enable Code button.