A2k mde from A2007 (1 Viewer)

[Lister]

I think the answer for this will be "no" but I will try anyway.

Can you create an Access 2000 .mde from Access 2007?

I know you can't from Access 2003 (which is what I am running at the moment.)

Thanks for any help guys.

 

[G37Sam]

Sure you can.. when saving the DB choose 1997-2003 format from the drop down

 

[Lister]

So in 2007 I can save a database as a (example) access 2000 database. Then, Tools > Create mde file > Browse to my shiny new access 2000 database and 2007 will create a access 2000 mde file?

Really! Thats great news, cause its a pain in access 2003.

Thanks

 

[boblarson]

Sure you can.. when saving the DB choose 1997-2003 format from the drop down

Nope, sorry, incorrect info alert

IF you want to be able to use it in the version it is saved in, you can ONLY create an MDE/ACCDE from the version you are saving it as. You can only create an ACCDE from 2007. You can only create a 2003 MDE from 2003, 2002 MDE from 2002, 2000 MDE from 2000.

You can create an MDE of a 2002-2003 format database in 2007 but if you try to open it in 2003 it will give you a "Database format not recognized" error.

 

[HiTechCoach]

I think the answer for this will be "no" but I will try anyway.

Can you create an Access 2000 .mde from Access 2007?

I know you can't from Access 2003 (which is what I am running at the moment.)

Thanks for any help guys.

When you make an MDE, THE compiled VBA will be for the version of Access that was used to create the MDE.

In Access 2007/2010, if you create an MDE, you will NOT be able to use it with a previous version of Access.

If you need a access 2000 version MDE, you will have to use Access 2000 to create it.

It is possible to install the Access 2007 or 2010 Runtime version for free from Microsoft. (Links here) You could then create a MDE from a 2002/2003 formated MDB using Access 2007. The MDE could be run with the Access 2007 or 2010 Runtime version.

 

[boblarson]

It would only work if you are using the Access 2007 Runtime or a full version of Access to use that MDE file.

 

[G37Sam]

Sorry for the misinfo.. 3 AM here I thought you were referring to just normal 2k format, missed the point where you wanted the locked mde one

 

[Lister]

No prob' mate.
It was as I suspected. Thanks for confirming for me guys, I thought I would ask before I made an assumption. I will have to have a think about how I am going to approach this wee project for future proofing.

Thanks '; )