AllowBypassKey setting on MDE file

[Simon Morley]

I currently have a 'front end' .mdb file which has table
links to the back end. Each time I change a form, for
example, I create a new .mde file which I distribute to
the users. I'd like to prevent users using the shift key
to view the DB window in the .mde file, but don't want to
set it as such in the master .mdb file as I need to use
the shift key when going in to develop.

Any ideas on how I can make AllowBypassKey specific to
the .mde version of the database?

Many thanks in advance.

Simon.

 

[Lynn Trapp]

Each time you make a development change in your master .mdb file, make a
copy of the master to a new file that you kiss the shiftkey bypass in and
create the .mde from that.

 

[Joan Wild]

I currently have a 'front end' .mdb file which has table
links to the back end. Each time I change a form, for
example, I create a new .mde file which I distribute to
the users. I'd like to prevent users using the shift key
to view the DB window in the .mde file, but don't want to
set it as such in the master .mdb file as I need to use
the shift key when going in to develop.

After you create your mde, just disable the shiftkey in it. It won't affect
your mdb.

 

[Albert D. Kallal]

You could use my shift key utility. It lets your browse to the file..and
set/un-set the shift key..

check out:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[Simon Morley]

Albert,

Great bit of kit, thanks for this.

SCM