Share via

database contains missing or broken reference to "entitypicker.dll" and fails to open with access file

Anonymous
2024-11-24T22:05:37+00:00

I am not familiar with access at all and am looking for some direction on how to attempt to fix this issue for my users. I am unable to even open the access file to then use VBA to deselect the reference and recompile. Older versions of office seem to work. This 11//2024 update broke my companies access db

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

3 answers

Sort by: Most helpful
  1. George Hepworth 22,855 Reputation points Volunteer Moderator
    2024-11-26T13:54:28+00:00

    FWIW.

    I found EntityPicker.dll in a backup folder for Office, and nowhere in the current installed version of Office. I think it's from Access 2010. I believe it is the old Date/Time Picker, now deprecated. Once you get to the References, you should be able to de-select it and resolve the problem.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-11-25T05:32:23+00:00

    Thanks Trying shift on startup and looking there! appreciated

    Was this answer helpful?

    0 comments No comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2024-11-24T23:49:34+00:00

    What that usually means is the Access application was developed with a third party DLL. To perform some function. That DLL may no longer be supported in the current version.

    Two options:

    Roll back the update to Office 365. Then see if the app opens and you can see what the DLL does and then remove it.

    Hold down the Shift Key as you start the application. This bypasses the start up code. You should then be able to open the VBE and remove the reference.

    Was this answer helpful?

    0 comments No comments