Access 2002 mde on Access 2007 system

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob Bunocore - 27 Mar 2007 03:05 GMT

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

Reply to this Message

Allen Browne - 27 Mar 2007 03:11 GMT

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.)

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a client who has 5 independent consultants working for her.
> Each person has their own machine and is responsible for installing
[quoted text clipped - 7 lines]
>
> Robby

Reply to this Message

Arvin Meyer [MVP] - 27 Mar 2007 03:12 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>I have a client who has 5 independent consultants working for her.
> Each person has their own machine and is responsible for installing
[quoted text clipped - 7 lines]
>
> Robby

Reply to this Message