I have built scripts into my database that allows users to create new records by clicking a button. This script actually only duplicates the previous record, as there are certain "hidden" fields that need to be on each record, a does a variety of other functions. Basically, the user thinks they are creating a new record rather than running a script.

Here's my question: Is there any way to prevent the user from using keyboard and menu shortcuts, forcing them only to use the scripted buttons. I have tried limiting access but it appears that once the "create" record option is deselected, the duplicate function does not work in my script either.

Any thoughts or suggestions would be greatly appreciated.

Change the 'Available Menu Commands' option in Access Privileges -> Passwords to either "None" or "Editing Only". Leave the 'Create' option selected and they will only be able to create records via script.