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

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

--
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.
"Rob Bunocore" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Rob Bunocore" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>