Fix Microsoft Access Function Name Errors in an ACCDE Database
Question details
Resolve intermittent 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.
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.
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.
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.
Exit Access on the affected workstation before replacing or copying the front-end file.
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.
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.
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.

Investigate the exact error and source database references
Use the error details to narrow down the cause if a fresh local front end does not resolve the issue.
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.

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.




