Question opening access 03 in 07.

[cdoyle]

I just upgraded to Access 07, and I'm working on an 03 DB. I need to create the MDE file, but maintain it in the 03 version so everyone else can still use the db.

When I create the MDE tho, nobody with 03 can open it anymore. They get an unrecognized format.

Is there a setting somewhere, that you have to click on to say 'keep in 03' when you create the MDE?

 

[boblarson]

You can't create an "03" MDE in 2007. To create an "03" MDE you need to use Access 2003. But, if your users can install and use the Access 2007 runtime then you can create your MDE in 2007 and have them run that file with the 2007 runtime (which is free).

 

[cdoyle]

You can't create an "03" MDE in 2007. To create an "03" MDE you need to use Access 2003. But, if your users can install and use the Access 2007 runtime then you can create your MDE in 2007 and have them run that file with the 2007 runtime (which is free).

UGH, I did not want to hear that.

I guess I'll have to ask to be downgraded back to 03, since they are only letting very few try out 07. Users aren't allowed to install the 07 runtime on their own.

Can both 03 and 07 be installed at the same time?

 

[boblarson]

Can both 03 and 07 be installed at the same time?

Yes, but it can be a bit of a pain to do so - especially if you are on Vista. If on XP, it is still a pain, but not so much so. It has to go through the "installing" process each time you open the other version after having one open.

 

[boblarson]

Or you could just go to another computer to make the MDE file, perhaps.

 

[cdoyle]

I'll see if our guys will let me have both version, otherwise going to have to convert back to 03.

Thanks for the info!!