I know someone else has had this headaches, but had a hard time finding anything in the forums on it.

I have an app I wrote in 2000.

Today, I went to install it at a client site.

The client runs 2002 (XP).

The first install went fine.

The next install, the MDE file didn't run properly. Lots of missing objects, etc.

I put the mdb file on the machine giving the problem, and it runs fine.

I want to recompile the code on the problem pc, but the Make MDE option is grayed out.
I went to the VB Editor and recompiled the project, but the MDE option is still grayed out.

ANy suggestions? I need to go back tomorrow. I would like to have an answer!

Thanks,

mcp.

I guess Access 2002 is installed in the client machine and your mdb is in Access 2000 Format.
We can't make MDE in this situation. You have 2 options here.
One is convert your mdb to Access 2002 Format.
Or use an undocumented feature as John suggested in thie POST. Don't open the target mdb and the code will do the job regardless the format of the target mdb.

I think the problem is that Access XP can read an Access .mdb with no problems, however, when you have an Access 2000 .mde there is a problem.

What I would suggest is that you take your Access 2000 .mdb and open it on the Client's Computer with Access XP, then Convert it to Access XP (the default is to open it as Access 2000 without converting). Then once converted into Access XP, create a .mde (the option should be available then) and have any clients running Access XP use that .mde

Let me know if you need more help with this.

HTH, Thanks.

Thanks.

I thought that's what I had to do (convert then compile).

I converted the code (at least I think I did) by selecting convert to Access 2002 from the Tools menu, but I still didn't have the Make MDE option enabled.

Will try again tomorrow.

Thanks.

mcp

Yes, you converted it correctly, however, you still have to open up the VBA Editor and Compile your code in order for the MDE Option to be available.

HTH, Thanks.