Shift ByPass

[alex]

Hello all,

Using Access ’03…

I’ve been reading this forum and doing some research about how to
disable the shift bypass.

I’ve found quite a bit of code about the topic, but nothing to meet
exactly what I need.

I have an mde that copies another mde and places it in a particular
location. I would like to permanently disable the shift bypass on
this mde (that does the copying) (knowing to keep ‘several’ copies of
mdb backups). The mde that I’d like to disable the shift bypass would
only take me minutes to reproduce, so I’m not too concerned.

I assume I’ll need to open the mde, run the code, save, exit, then
forever be unable to bypass the auto startup.

Is that possible to do? If so, any code examples?

I also thought this would be cool: run some code that changes the
shift bypass to something else bypass; e.g., ctrl bypass, or something
only the dba would know.

I wonder if that’s possible?

alex

 

[Jeff Boyce]

Alex

Perhaps it's just an issue with terminology ...

The Access .mde file is akin to an executable, and you should NOT be able to
open it and modify its code. You'd need to do that in the .mdb version,
then save it as an .mde version.

(or maybe I'm just confused!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello all,

Using Access ’03…

I’ve been reading this forum and doing some research about how to
disable the shift bypass.

I’ve found quite a bit of code about the topic, but nothing to meet
exactly what I need.

I have an mde that copies another mde and places it in a particular
location. I would like to permanently disable the shift bypass on
this mde (that does the copying) (knowing to keep ‘several’ copies of
mdb backups). The mde that I’d like to disable the shift bypass would
only take me minutes to reproduce, so I’m not too concerned.

I assume I’ll need to open the mde, run the code, save, exit, then
forever be unable to bypass the auto startup.

Is that possible to do? If so, any code examples?

I also thought this would be cool: run some code that changes the
shift bypass to something else bypass; e.g., ctrl bypass, or something
only the dba would know.

I wonder if that’s possible?

alex

 

[alex]

Alex

Perhaps it's just an issue with terminology ...

The Access .mde file is akin to an executable, and you should NOT be ableto
open it and modify its code.  You'd need to do that in the .mdb version,
then save it as an .mde version.

(or maybe I'm just confused!)

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hello all,

Using Access ’03…

I’ve been reading this forum and doing some research about how to
disable the shift bypass.

I’ve found quite a bit of code about the topic, but nothing to meet
exactly what I need.

I have an mde that copies another mde and places it in a particular
location.  I would like to permanently disable the shift bypass on
this mde (that does the copying) (knowing to keep ‘several’ copies of
mdb backups).  The mde that I’d like to disable the shift bypass would
only take me minutes to reproduce, so I’m not too concerned.

I assume I’ll need to open the mde, run the code, save, exit, then
forever be unable to bypass the auto startup.

Is that possible to do?  If so, any code examples?

I also thought this would be cool:  run some code that changes the
shift bypass to something else bypass; e.g., ctrl bypass, or something
only the dba would know.

I wonder if that’s possible?

alex

Hi Jeff,

We're on the same page...
I know you cannot modify the code of an mde, but you can still bypass
its execution by holding the shift key. I was looking for code to
permanently disable the shift bypass.

I was also inquiring if anyone knew how to transfer "bypass"
responsibility to another key; e.g., Ctrl bypass key.

Thanks,
alex

 

[Douglas J. Steele]

You can stop the use of Shift Bypass by creating a database property named
AllowBypassKey and setting its value to false. See
http://www.mvps.org/access/api/api0068.htm at "The Access Web" for the
correct way to do this.

You cannot change the Bypass Key to some other key.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Alex

Perhaps it's just an issue with terminology ...

The Access .mde file is akin to an executable, and you should NOT be able
to
open it and modify its code. You'd need to do that in the .mdb version,
then save it as an .mde version.

(or maybe I'm just confused!)

Regards

Jeff Boyce
Microsoft Office/Access MVP


Hello all,

Using Access ’03…

I’ve been reading this forum and doing some research about how to
disable the shift bypass.

I’ve found quite a bit of code about the topic, but nothing to meet
exactly what I need.

I have an mde that copies another mde and places it in a particular
location. I would like to permanently disable the shift bypass on
this mde (that does the copying) (knowing to keep ‘several’ copies of
mdb backups). The mde that I’d like to disable the shift bypass would
only take me minutes to reproduce, so I’m not too concerned.

I assume I’ll need to open the mde, run the code, save, exit, then
forever be unable to bypass the auto startup.

Is that possible to do? If so, any code examples?

I also thought this would be cool: run some code that changes the
shift bypass to something else bypass; e.g., ctrl bypass, or something
only the dba would know.

I wonder if that’s possible?

alex

Hi Jeff,

We're on the same page...
I know you cannot modify the code of an mde, but you can still bypass
its execution by holding the shift key. I was looking for code to
permanently disable the shift bypass.

I was also inquiring if anyone knew how to transfer "bypass"
responsibility to another key; e.g., Ctrl bypass key.

Thanks,
alex

 

[alex]

You can stop the use of Shift Bypass by creating a database property named
AllowBypassKey and setting its value to false. Seehttp://www.mvps.org/access/api/api0068.htmat "The Access Web" for the
correct way to do this.

You cannot change the Bypass Key to some other key.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)


















Hi Jeff,

We're on the same page...
I know you cannot modify the code of an mde, but you can still bypass
its execution by holding the shift key.  I was looking for code to
permanently disable the shift bypass.

I was also inquiring if anyone knew how to transfer "bypass"
responsibility to another key; e.g., Ctrl bypass key.

Thanks,
alex- Hide quoted text -

- Show quoted text -

Thanks Doug; I'll check it out.