Access 2013 - mde file

My OS is win 7 prof 64 bit and I use Access 2013.  I have created a small contacts application, and am tring to create an MDE file, because I do not want the others to poke around at the code and give me a headache.
1.   How do I create an Mde file?
2.   How does one open this file, does the user need to have Access 2013 to open it?
Thank u and regards.
jegajothyretiredAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

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

Kelvin SparksCommented:
1. Click the file menu in Access 2013, and choose Save as. Choose the Make mde option.
2. They can either use Access 2013 (full) or they can download a runtime of Access 2013 which will let them use the mde (or an accdb) with being about to change objects). The runtime is free. Built in help etc is gone, so you need good error handling s they won't get any useful infor if an error occurs.


Kelvin
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Note the default format for 2013 is the .accdb format, not the .mdb format. If you've created a .accdb file, then you'll save it as an .ACCDE file, not a .mde file.

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
jegajothyretiredAuthor Commented:
thank u
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Couple other things you need to be aware of:

1. A MDE/ACCDE is nothing more than a normal DB with the source code stripped out.   So your code is protected, but nothing else.

2. Because of #1, make sure your app is compiled without errors before you try converting.  You can't generate a MDE if it won't compile cleanly.

3. Be aware of your Office version.  Office 2010 and up come in two versions; 32 and 64 bit (this is not what your OS is - a 64 bit OS can run 32 or 64 bit programs).

   If your Office is 64 bit, then your user will need the 64 bit runtime.  Likewise if 32 bit, they need 32 bit Access (full or runtime).

   So you may need two versions of the app because Office components cannot be mixed (64 bit Excel, 32 bit Access) within the same version.

4. All that aside, if your only goal is to protect the code, then you can apply a VBA project password and forget about MDE's entirely.

HTH
Jim.
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.