Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 29th, 2007, 02:24 PM
Registered User
 
Join Date: Aug 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Starting

I have a program that was written by one of our staff but when he told me that all you have to do to open the program in edit mode is to highlight the icon then press and hold the shift key then press enter and you go straight into the edit mode allowing anyone access to make changes. I can't allow this to be out at our other sites. Is there anyway to lock this feature so that they can only run the program?

Thanks,
Don


 
Old August 30th, 2007, 09:04 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You can convert the application to an mde.

Do users use a shortcut, or the actual application? I would send them a shortcut and then connect that to an mde file. Then replace it whenever you make updates.

Otherwise, I think there is another work around, which I can't remember, but that may lock you out of the application as well.

mde's are good for this.

I hope that helped in some way.I can look up other methods if you want them.

mmcdonal
 
Old August 30th, 2007, 09:34 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Welcome, Don,

Here is an example from Thomson's New Perspectives in Access:
1) code example to change the bypass key is available in Access VBA help. Search for "allowbypasskey property"
2) Add the following function to a code module:



 
Old August 30th, 2007, 10:02 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

OOps- hit the tab key!

Welcome, Don,

Here is an example from Thomson's New Perspectives in Access:

1) code example to change the bypass key is available in Access VBA help. Search for "allowbypasskey property". You can use MS's code example (cut and Paste) found there for the sub SetByPassProperty() and function ChangeProperty
2) Add the following function to a code module:

     Function SetByPassProperty(bValue as boolean)
     Const DB_Boolean as long = 1
           ChangeProperty "AllowBypassKey", DB_Boolean, bValue
     End Function
3) create a macro naming it the reserved word AutoKeys
     a)create a macrogroup named AutoKeys. Choose what key combination to use to set the bypass key to true and enter those keys as the macro name. (insert, delete and function keys are surrounded by curly braces)
     b) choose RunCode from Action list. Enter "setBypassProperty(true)" as the function name in the macro pane.

     c) On the next line of the macrogroup, enter the key combination to turn off the bypass key under macro name. Enter "RunCode" under Action and finally "SetBypassproperty(false)" on the Function Name to all your function.
 ++++++++++++++
It allows you to open the db, then use the key combination chosen to override the bypass key. When you close and re-log in, the shift key will not bypass. TO enable the shift key, open the database, depress the keys selected to enable bypass, then exit the db. Your shift key should bypass.

HTH











Similar Threads
Thread Thread Starter Forum Replies Last Post
Starting Tomcat seyyed JSP Basics 3 August 24th, 2006 02:20 PM
Just starting... lozbritt9 C++ Programming 1 March 10th, 2006 12:54 PM
Starting Off Correctly... JESwan XML 0 April 28th, 2005 08:01 AM
Mysql Starting rajuru PHP Databases 2 September 9th, 2004 11:59 AM
problem starting access stoneman Access 1 December 2nd, 2003 06:49 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.