Access XP & MDE Files

Sorrells

Registered User.
Local time
Today, 11:24
Joined
Jan 13, 2001
Messages
258
Greetings,

I cannot load an Access97 MDE file in Access XP. The Help in XP does not have the keyword "MDE". Of course, there is no index in the XP Developer's Guide.

Does anyone know what Microsoft did with this capability. My program MDE runs fine in Access97 and 2000.
 
I understood that a 97 MDE cannot be loaded in XP if this is required you must load the MDB and convert it to MDE once in XP. There is something about this in Microsoft knowledge base.
 
Dynamictiger,

You are correct. I found out and should have updated this thread. I still shake my head in wonderment that the keyword MDE is not in the Access XP Help file! Most of my programming is in Access97 and would be curious if there is any overwhelming reason to fully move to XP or even 2000 for that reason.

I found the article in the Knowledge Base but neglected to save the number or link. I have copied the essential steps from the article at the end of this reply.

In actuality, I had to take the Access MDB, convert it to 2000 MDB then to XP MDB and then the grayed out MDE function under the Tools menu became active. Anyone reading this should be aware that an important check prior to conversion is to open a module and run Debug/Compile and Save All Modules as if there is an error, the MDE file will not be created.

Thank you for your response!
=========================================
Convert the MDB of ADP file to the Access 2002 format. To do so, follow these steps:
1. Start Access.
2. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002 File Format.
3. In the Database to Convert From dialog box, select your database, and then click Convert.
4. In the Convert Database Into dialog box, specify the name of the new Access 2002 database, select the location where you want to store the new file, and then click Save.
5. Click OK to complete the conversion.
6. Open the newly created file. Note that the Make MDE File (or Make ADE File) command is now available on the Database Utilities menu on the Tools menu.
 

Users who are viewing this thread

Back
Top Bottom