AllowBypassKey with an .MDE file

26 Feb 2009 2:01 PM

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

27 Feb 2009 2:02 AM

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

Show quoteHide quote

"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/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?

27 Feb 2009 3:56 AM

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

Show quoteHide quote

"Harvey" <Har***@discussions.microsoft.com> wrote in message
news:5CEA0800-2F4D-4F9F-9B63-34EBCD8D5FA8@microsoft.com...
> 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

3 Mar 2009 5:35 PM

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.

Show quoteHide quote

"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" <Har***@discussions.microsoft.com> wrote in message
> news:5CEA0800-2F4D-4F9F-9B63-34EBCD8D5FA8@microsoft.com...
> > 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
>
>
>