Others

Fix Unresponsive Login Buttons in Microsoft Access

Khadija KhanKhadija Khan Nov 14, 2026 868 views

Question details

The user needs to restore the OK and Cancel buttons on an Access login form.

Fix Unresponsive Login Buttons in Microsoft Access
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.
Before you start

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.

Solution 1Recommended

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.

1
Check the security warning

Open the database in Access. If a security warning appears, select Enable Content only after confirming that the file and its source are trustworthy.

2
Review trusted locations

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.

3
Inspect the button events

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.

4
Test the assigned action

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.

Check Access Trust Settings and Button Click Events
Trust only verified files: Enabling content or trusting a location allows active content to run. Do not use these settings for a file or folder you do not trust.
Free Microsoft Office alternative

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.

Work with familiar document, spreadsheet, and presentation toolsOpen and edit Microsoft Office formats including DOCX, XLSX, and PPTXUse a free, lightweight suite alongside Access for non-database tasksMove common Office files without learning an entirely new interface
microsoft office alternative - wps office

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.