Fix Unresponsive Login Buttons in Microsoft Access
Question details
The user needs to restore the OK and Cancel buttons on an Access login form.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A login form uses macros or event procedures, and the database may be shared among multiple users.
- Observed behavior
- The OK and Cancel buttons do not respond when clicked.
Confirm that the database comes from a trusted source and find out whether users open the same database file from a shared folder. If you need to inspect button settings, open the form in Design View.
Check Access Trust Settings and Button Click Events
Use this solution to check whether Access has blocked the login macro or the buttons lack working click events.
Open the database in Access. If a security warning appears, select Enable Content only after confirming that the file and its source are trustworthy.
Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. If appropriate, add the trusted folder containing the database, then close and reopen the file. Organization policies may restrict this setting.
In the Navigation Pane, right-click the login form and select Design View. Select each button, open the Property Sheet, and check the On Click setting on the Event tab for an assigned macro or event procedure.
Use the build button next to On Click to inspect the assigned macro or VBA procedure. Correct any missing or invalid action, then switch to Form View and test both buttons.

Split a Shared Access Database for Multiple Users
Use a split database when multiple users currently open the same Access file; this improves the sharing setup but may not fix a faulty button event.
Use WPS Office for Everyday Office Documents
WPS Office is a free, lightweight alternative for everyday documents, spreadsheets, and presentations. Its familiar interface and Microsoft Office format support make it easy to move common files, though it does not repair or run Access database macros.

Frequently Asked Questions
Why do my Access login buttons do nothing?
Access may have disabled active content, or the buttons' On Click events may be missing or invalid. Check the security warning, then inspect each button's On Click property in Design View.
Where can I check trusted locations in Access?
Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations. Add a folder only if you trust its contents and your organization permits it.
Can multiple users share one Access database?
For multiuser access, split the database so the tables are in a shared back end and each user has a separate local front end. Use Database Tools > Access Database to start the splitter.
Will splitting the database fix every unresponsive button?
No. Splitting improves the multiuser setup, but a disabled macro or an incorrect On Click event still needs to be checked in the local front end.




