To Sync Or Not To Sync (ASYNC) ODBC Queries

To Sync Or Not To Sync (ASYNC) ODBC Queries

Here you are in VB3, you have loaded the compatibility layer for Jet2.0, and you are using ODBC. In this configuration, the ODBC queries willalways run in asynchronous query execution mode, no matter if DisableAsyncis set to one or zero in the application’s initialization file. Fortunately,the fix for this is readily available in the form of a new DLL in the MicrosoftAccess Service Pack, which upgrades the Jet Engine (MSAJT200.DLL) to version2.50.1606. When the VB compatibility layer is installed, the Jet Engine is upgradedfrom version 1.0 to version 2.0. If the Microsoft ODBC Desktop DatabaseDrivers are then installed, the Jet Engine (MSAJT200.DLL) will be upgradedto version 2.50.1117, which forces a VB application into asynchronous queryexecution mode forever.

See also  Small Business Strategies with Venmo

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist