Jegajothy vythilingam
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank u
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.
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.
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