Access 2002 mde on Access 2007 system

[Rob Bunocore]

I have a client who has 5 independent consultants working for her.
Each person has their own machine and is responsible for installing
Access. I am about to distribute a new system using an Access
2002.mde Of course I get an email today informing me that ONE of the
users has just upgraded to Access 2007.

I am not going to have a lot of time to test this before I
distribute. Is there any possiblity of her running this mde on her
machine without error? My code is fairly straight forward.

Robby

 

[Allen Browne]

Yes, that's possible.

You have a good chance of getting it to work if:
a) You have Name AutoCorrect off:
http://allenbrowne.com/bug-03.html

b) You use minimal library references:
http://allenbrowne.com/ser-38.html

c) You decompile and then compact before you create the MDE.

To be really sure, it might be a good idea to create a new (blank) MDB, and
import everything after performing the 3 steps above, and before creating
the MDE. I skipped this 4th step recently, and the Access 2000 MDE refused
to run on Access 2003. It would not even open without crashing (A2003 shut
down by Windows.)

 

[Arvin Meyer [MVP]]

It will probably run OK, but the only way to know for sure is to try it out.
If there is a problem, hopefully this person is close by and you can simply
install and mdb and recompile it, then make an MDE and delete your starting
file.