Access 2007 & 2003 : Creating an mde for 2003 users with a 2007 dev copy issues

Question

So i have an image on my computer that has office 2007, and I have the development copy of this database file where I corrected some code, added some fields, etc...

I then converted the Access file (.mdb dev file) to Access 2002-2003 format to create an mde. So I then created the new mde, but when users try to open, it gives them the message that it is not the correct format and that they should upgrade to a newer version of access.

So will i be able to get this done with having office 2007, and these other end users not having their new image pushed yet (so they still have office 2003)? I thought that if I converted the file to 2002-2003 then this should not be a problem>

Thanks Justin

Answer 1

If you create the MDE in the lowest version of Access involved, it should be usable by all later versions. The format of the MDB file (A2000, A2002/2003, A2007) is separate from the version of Access, as what's relevant to the MDE is which version of VBA is executing the compiled p-code in the MDE. An A2000-format file compiled in A2007 won't run on A2000, for instance, but if compiled in A2000, should be runnable ay A2000, A2002, A2003, A2007 and A2010.

But I'm not entirely certain about this. It could be there's a break from A2003 to A2007/2010. Also, I don't use MDEs that much, and not at all in mixed deployment environments.