Error:

Run-time error 3709: The connection cannot be used to perform this operation. It is either closed or invalid in this context.

Snapshot:

Workaround 1: Unregister and Re-register the DAO350.dll using Regsvr32.

1. Open Command prompt as Administrator
2. Type Regsvr32 /u “C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL”.
3. Click enter to unregister.
4. Type Regsvr32 /u “C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL”.
5. Click enter to register it.

Workaround 2: Run the application always as administrator.

Right click the Application shortcut and Go to Properties set Run as Administrator.