• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 707
  • Last Modified:

How to convert Access 2003 database to MDE format

After having created a database in Access 2003, I am unable to convert it to the MDE format.
Do I need to purchase a special software which will enable me to implement security features and to convert the database to a format where it does not require Access 2003 installed on client's systems to be used?
Any help will be very much appreciated
0
MonsurR32
Asked:
MonsurR32
4 Solutions
 
KCTSCommented:
MDE format simply compiles the Access database. It does not enable it to run without Access. If you want to distribute Access databases with the access runtime then you need to have the Access Delevloper Tools see http://office.microsoft.com/en-us/access/HA011208861033.aspx. The developer tools provide you with the run-time and all sorts of tools for packaging an distrubuting your application.

That said you should still be able to create an MDE and use the security tools without the developer tools. You will need to have exclusive access to the database to do this. Use File, Open to open the database, and on the OPEN button nect to the filename, select Open Exclusive.

You can then run the security wizard and make an MDE file.
0
 
DoubleJ92Commented:
You have to make sure your mdb will compile before it can become an mde. Open a code window, then go to Debug->Compile. Fix any errors and try to compile again. Repeat until it compiles successfully. Close the code window and save everything. Now you should be able to go to Tools->Database Utilities->Create MDE and have it successfully create your mde.
0
 
stevbeCommented:
You will only be able to create an MDE of the same file format as the version of Access you have. So if you have Access 2003 the file format MUST be 2003 in order to make it an MDE. In other words ... you can't make a 2000/2002 file format into an MDE with Access 2003.

Steve
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<You can then run the security wizard and make an MDE file.>

Actually, this is incorrect. You do NOT run the security wizard to create an MDE file, but instead you use Tools - Database Utilities - Make MDE file. Other caveats by DoubleJ92 and Steve apply as well.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now