AllowBypassKey with an .MDE file

[Harvey]

Hello:

We ship our app (acc 2003) as .MDE and would like to incorporate either of
the solutions for preventing a user from pressing SHFT (to bypass an Access
application and see the back end database):

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
or
http://support.microsoft.com/kb/826765#appliesto

both of these work on the .mdb, but how would I do this with .mde? Once
bypass key is run, the menus are no longer available, so I can no longer
create the .mde. is there a command line tool to create the .mde? or some
other solution someone might be aware of?

thank you in advance for any advice.

Regards,
Harvey



would work with an .mde file? In other words, we ship

 

[Chris O''C]

Change the code to point to the mde file instead of using currentdb, which is
only useful in the current db file.

Change this line of code:

Set db = CurrentDb()

to this:

Set db = OpenDatabase("C:\Data\db.mde")

or whatever path and file name you choose. This code resides in a module in
a db file that *isn't* your mde file.

If you want it to be reusable and not hardcoded, put a text box on a form.
Read the value the user typed in the form for the path and file name to turn
on/off allowbypasskey for that db file.


Chris

 

[Jeanette Cunningham]

Hi Harvey,
create your mde, set up everything for it. When it is set up with startup
options, and autoexec or autokeys macros (if you use them); as the very last
step, disable the shift bypass with the links below.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Harvey]

thanks both. I ended up using Jeanette's solution, since we didnt have to
code anything. I thought I had tried earlier and it did not work on an MDE,
but it certainly does.

thanks again.