calling Michael Kaplan's securing allowbypasskey function

[Silvester]

Can someone tell me how & where to call the shift key bypass code
Function ChangePropertyDdl(stPropName As String, _
PropType As DAO.DataTypeEnum, vPropVal As Variant) _
As Boolean

found at

http://www.mvps.org/access/general/gen0040.htm

How should I call this function & from where ?

 

[Joan Wild]

That code is a substitute for the ChangeProperty function that is provided
in the sample in Help i.e. it is called by a separate procedure.

Look at the sample in the security FAQ
http://support.microsoft.com/?id=207793

If you use that you just need to call the function once (Ctrl-G and type
faq_DisableShiftKeyBypass. The next time the database is opened, the
shiftkey will be disabled

 

[Silvester]

Thanks very much. I had to amend the dim statements to include
dao.workspace, etc as it was not working for me.

Is this alright ?