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 - 28 Apr 2004 14:21 GMT
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.

Signature
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
> I currently have a 'front end' .mdb file which has table
> links to the back end. Each time I change a form, for
[quoted text clipped - 10 lines]
>
> Simon.
Joan Wild - 28 Apr 2004 16:44 GMT
> I currently have a 'front end' .mdb file which has table
> links to the back end. Each time I change a form, for
[quoted text clipped - 3 lines]
> 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.

Signature
Joan Wild
Microsoft Access MVP
Albert D. Kallal - 28 Apr 2004 21:02 GMT
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
--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
pleasenonoSpamKallal@msn.com
http://www.attcanada.net/~kallal.msn
Simon Morley - 29 Apr 2004 14:49 GMT
Albert,
Great bit of kit, thanks for this.
SCM
>-----Original Message-----
>You could use my shift key utility. It lets your browse to the file..and
[quoted text clipped - 10 lines]
>
>.