https://support.microsoft.com/fr-fr/kb/826765/fr

CODE
Étapes à suivre pour une base de données Access (.mdb ou .accdb)

Démarrez Access.
Créer un nouveau module, puis ajoutez les deux fonctions suivantes :

----------------------------------------------------
Function ap_DisableShift()
'This function disable the shift at startup. This action causes
'the Autoexec macro and Startup properties to always be executed.

On Error GoTo errDisableShift

Dim db As DAO.Database
Dim prop as DAO.Property
Const conPropNotFound = 3270

Set db = CurrentDb()

'This next line disables the shift key on startup.
db.Properties("AllowByPassKey") = False

'The function is successful.
Exit Function

errDisableShift:
'The first part of this error routine creates the "AllowByPassKey
'property if it does not exist.
If Err = conPropNotFound Then
Set prop = db.CreateProperty("AllowByPassKey", _
dbBoolean, False)
db.Properties.Append prop
Resume Next
Else
MsgBox "Function 'ap_DisableShift' did not complete successfully."
Exit Function
End If

End Function

Function ap_EnableShift()
'This function enables the SHIFT key at startup. This action causes
'the Autoexec macro and the Startup properties to be bypassed
'if the user holds down the SHIFT key when the user opens the database.

On Error GoTo errEnableShift

Dim db as DAO.Database
Dim prop as DAO.Property
Const conPropNotFound = 3270

Set db = CurrentDb()

'This next line of code disables the SHIFT key on startup.
db.Properties("AllowByPassKey") = True

'function successful
Exit Function

errEnableShift:
'The first part of this error routine creates the "AllowByPassKey
'property if it does not exist.
If Err = conPropNotFound Then
Set prop = db.CreateProperty("AllowByPassKey", _
dbBoolean, True)
db.Properties.Append prop
Resume Next
Else
MsgBox "Function 'ap_DisableShift' did not complete successfully."
Exit Function
End If

End Function
--------------------------------------------------------
Quitter la fin de la fonction Si End Function
Dans l'éditeur Visual Basic, cliquez sur Fenêtre Exécution dans le menu Affichage .
Si vous souhaitez désactiver la touche MAJ, tapez ap_DisableShift dans la fenêtre Exécution et appuyez sur ENTRÉE . Si vous souhaitez activer la touche MAJ, tapez ap_EnableShift dans la fenêtre Exécution et appuyez sur ENTRÉE .