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/AlbertKal.../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

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

"Harvey" wrote:

> 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/AlbertKal.../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?

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" <(E-Mail Removed)> wrote in message
news:5CEA0800-2F4D-4F9F-9B63-(E-Mail Removed)...
> 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/AlbertKal.../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

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.



"Jeanette Cunningham" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:5CEA0800-2F4D-4F9F-9B63-(E-Mail Removed)...
> > 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/AlbertKal.../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
>
>
>