MS Access 2007 accde / accdr Security Help 2

[stevedemo]

Ok, 2007 is not bad but it is a different animal.

I would like to distribute a database but obviously I want to lock it so it can not be altered. So naturally I would want to use the accde extension. Fine and dandy until you add VB to the project then it shuts off all the macros and VB.

I was reading here:

http://msmvps.com/blogs/officept/ar...ccde-with-office-runtime-2007-extensions.aspx

that you can change the accdb to a accdr to put it in "lock down" mode. However you only need to change the extension to alter it. Is there another way ?

All I want is the chance to prove money won't make me happy.

 

[stevedemo]

I managed to find an answer - I found a forum where someone had the exact same issue. Nothing working when I generated a ACCDE file.

This is what I did to fix it, open the visual basic editor under "debug" select compile. Then from the Access 2007 GUI select the "Make ACCDE" on the ribbon. And all the functions started working in the ACCDE file.

So far it works GREAT !!. I only had to invoke the VB compiler once. And since it has been compiling the projects as it should. Must be a unreported bug.

Here is the orginal thread:

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1444593&page=&view=&sb=5&o=&vc=1

Steve


All I want is the chance to prove money won't make me happy.