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
MonsurR32Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian PiercePhotographerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.