AllowBypassKey in an adp - is this possible? 1

[LLou]

I am working on a MS Access Project (adp) in Access XP which links to a MS-SQL 2000 database. I have defined user rights through a combination of the adp form properties and the MS-SQL users and roles.

I would like to further protect the front end by disabling the Bypass key (holding down the shift key to bypass the startup) which allows any user with the know-how to access the Access object window. I have previously done this in an mdb using the standard AllowByPassKey vba function as defined in Help, but I am having difficulty creating a similar property for an Access Project (using the Add method of the AccessObjectProperties of the CurrentProject).

Can anyone offer any suggestions on this? Any help is much appreciated!

Thanks

 

[VBslammer]

This works for me on Access 2000 ADPs:

On Error Resume Next
CurrentProject.Properties.Add "AllowBypassKey", False

VBSlammer

Unemployed in Houston, Texas

 

[LLou]

Thanks for that VBSlammer! It worked in Access XP just perfectly.