Share via

Microsoft Access: A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control

Anonymous
2021-10-13T03:47:03+00:00

Hi

how do i resolve this issue?

Microsoft 365 and Office | Access | For home | 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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-10-14T08:05:02+00:00

    Yes, i tried to debug according to your suggestion but it didnt work.. currently i do not have any VBA ongoing

    Was this answer helpful?

    0 comments
  2. ScottGem 68,810 Reputation points Volunteer Moderator
    2021-10-13T12:06:04+00:00

    What is the expression in the On Click event? Have you checked for Missing references (Press Ctrl+G and select Tools References)? As it worked before?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-10-13T08:34:25+00:00

    how do i perform Cnr?

    Click on File > Info > Compact & Repair Database

    However, I doubt that will solve this problem. I'd start by ensuring that you do not have any compile errors. Open any module (tap the <Ctrl> and <G> keys simultaneously, to open the VBA Editor, with the Immediate Window displayed). Then click on Debug > Compile ProjectName, where ProjectName is the name of your VBA project--it may be the same as the name of your database. Do you get any compile errors?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-10-13T05:43:42+00:00

    how do i perform Cnr?

    Was this answer helpful?

    0 comments
  5. DBG 11,711 Reputation points Volunteer Moderator
    2021-10-13T04:37:10+00:00

    Have you tried performing a C&R? If it doesn't help, you might try decompiling your project next.

    Was this answer helpful?

    0 comments