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

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

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:

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