jeffreymiller
New member
- Local time
- Today, 09:43
- Joined
- Apr 20, 2013
- Messages
- 6
I have an Access 2003 database application with user-level security which now needs to run on Access 2016. I’ve made all necessary updates so it runs almost without a hitch in Access 2016. Everything works fine except for being able to open the “User and Group Accounts” dialogue box when I save it as an *.mde file. I have a command button with the following “On Click: [Event Procedure]:
Private Sub CmndSecurity_Click()
On Error GoTo Err_CmndSecurity_Click
' check if current user is in Admins
If CurrentUserInGroup("Admins") = True Then
'Displays the Security User and Group Accounts dialog box
RunCommand (acCmdUserAndGroupAccounts)
Else
' If current user is not in the Admins group display the following message
MsgBox ("You must have Admins permission to access Security Accounts")
End If
Exit_CmndSecurity_Click:
Exit Sub
Err_CmndSecurity_Click:
MsgBox Err.Description
Resume Exit_CmndSecurity_Click
End Sub
When I click on the command button in the *.mdb file the “User and Group Accounts” dialogue box opens successfully. However, when I save my application as an *.mde file and click on the command button, the following error occurs: “Microsoft Access has stopped working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.”
Any idea why it works in the *.mdb version and not the *.mde version?
Your insight would be greatly appreciated.
Private Sub CmndSecurity_Click()
On Error GoTo Err_CmndSecurity_Click
' check if current user is in Admins
If CurrentUserInGroup("Admins") = True Then
'Displays the Security User and Group Accounts dialog box
RunCommand (acCmdUserAndGroupAccounts)
Else
' If current user is not in the Admins group display the following message
MsgBox ("You must have Admins permission to access Security Accounts")
End If
Exit_CmndSecurity_Click:
Exit Sub
Err_CmndSecurity_Click:
MsgBox Err.Description
Resume Exit_CmndSecurity_Click
End Sub
When I click on the command button in the *.mdb file the “User and Group Accounts” dialogue box opens successfully. However, when I save my application as an *.mde file and click on the command button, the following error occurs: “Microsoft Access has stopped working
A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.”
Any idea why it works in the *.mdb version and not the *.mde version?
Your insight would be greatly appreciated.