What's the difference between the two? Will my database continue to work in exactly the same way if I convert?ghudson said:Nothing is totally secure but Access 2003 security is much stronger than previous versions. Convert the MDB into a MDE if you want more protection for your code.
Does the MDE work as an exe copy even if not exactly in the same way?pdx_man said:Yes, it will. Just be sure to keep the MDB version as your master copy. Make updates to it, create a new MDE and push it out.
One thing you will miss is the ability to do code breaks on errors, but then you should be able to replicate issue on your master copy and debug it there.
Alright. Thanks,Fear Naught said:No the MDE is not an EXE file. Users still need to have MS Access installed. What an MDE does is restrict design access to forms, macros and modules.
Thanks, that sounds great.jkl0 said:Just make sure you split the DB, create MDE from Front-End (FE) and keep the Back-End (BE) as an MDB.
Hoope this helps?
I would actually like to go for the second one in this situation which is "No readers".The_Doc_Man said:The REAL question is to define what you mean when you say "protect VBA code." As in - no readers? or just no modifiers?
If no modifiers, Workgroup protection is strong enough to allow that. Just don't grant WRITE or UPDATE or DELETE access to the modules and forms.
If no readers, you must use the MDE method suggested above.
Do you mean I will lose the ability to debug only on the MDE version not the MDB?pdx_man said:Yes, it will. Just be sure to keep the MDB version as your master copy. Make updates to it, create a new MDE and push it out.
One thing you will miss is the ability to do code breaks on errors, but then you should be able to replicate issue on your master copy and debug it there.
Bee said:Do you mean I will lose the ability to debug only on the MDE version not the MDB?
That sounds great. Thank you.pdx_man said:You can leave the BE in 2002, but it may be easier to maintain going forward if both are in the same version. Setting a password for the MDE is optional and can be done in the MDB or the MDE.