Others

Fix Microsoft Access Function Name Errors in an ACCDE Database

Muhammad TalhaMuhammad Talha Nov 14, 2026 870 views

Question details

Resolve intermittent function name errors in a Microsoft Access ACCDE database.

Fix Function Name Errors in a Microsoft Access ACCDE Database
Product
Microsoft Access
Device & OS
not provided
Scenario
Users run an ACCDE front end that connects to a database back end on a server.
Observed behavior
Access intermittently reports that it cannot find a function name, even though references and trusted locations appear to be configured.
Before you start

Ask the affected user to capture the complete error message and any error number. Identify where the ACCDE front end and the server back end are stored.

Solution 1Recommended

Run a fresh ACCDE front end locally on each workstation

Use a separate local front end for each user to avoid problems associated with sharing the front-end file on a server.

1
Check the front-end location

On an affected workstation, check the shortcut or launcher used to open the ACCDE file. Confirm whether it points to a local folder or a shared server folder.

2
Close the front end

Exit Access on the affected workstation before replacing or copying the front-end file.

3
Copy a fresh front end locally

Copy a known-good ACCDE front end to a local folder on the workstation. Leave the database back end on the server and preserve the front end's links to it.

4
Trust the local folder

In Access, open File > Options > Trust Center > Trust Center Settings > Trusted Locations, then add the local front-end folder if it is not already trusted.

5
Open and test the local copy

Open the local ACCDE directly or update the existing launcher to point to it. Repeat the action that produced the error and record the result.

Run a fresh ACCDE front end locally on each workstation
Keep front ends separate: Give each workstation its own local front-end copy. The server back-end location does not need to be a trusted location merely because the front end links to it.
Free Microsoft Office alternative

Use WPS Office for Everyday Office Documents

WPS Office is a free, lightweight alternative for working with documents, spreadsheets, and presentations in a familiar interface. Its Microsoft Office format compatibility makes it easier to move everyday files between suites. It does not replace Microsoft Access or fix ACCDE errors.

Work with DOCX, XLSX, and PPTX files for easier migration from Microsoft Office.Use a familiar interface for common document and spreadsheet tasks.Choose a lightweight, free suite for everyday office work.Keep using Microsoft Access for ACCDE databases while managing other office files in WPS.
microsoft office alternative - wps office

Frequently Asked Questions

Should the Access ACCDE front end be stored on the server?

A separate local front-end copy on each workstation is recommended. Keep the shared back-end database on the server and have each local front end link to it.

How do I add the local front-end folder as a trusted location?

In Access, go to File > Options > Trust Center > Trust Center Settings > Trusted Locations and add the folder containing the local ACCDE.

What should I record when the function name error appears?

Record the complete message, any error number, and the action, form, or report involved. These details can help distinguish a reference issue from another cause.

Can I fix missing VBA references directly in an ACCDE?

Generally, reference and VBA changes should be made in the original ACCDB source. Open its VBA editor with Alt+F11, check Tools > References, compile the project, and create a new ACCDE.

Can WPS Office open or repair an Access ACCDE database?

No. Use Microsoft Access to run and troubleshoot ACCDE databases. WPS Office is an alternative for files such as Word documents, Excel spreadsheets, and PowerPoint presentations.