Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Security / April 2004

Tip: Looking for answers? Try searching our database.

AllowBypassKey setting on MDE file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simon Morley - 28 Apr 2004 13:42 GMT
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]
>
>.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.