devxlogo

To Sync Or Not To Sync (ASYNC) ODBC Queries

To Sync Or Not To Sync (ASYNC) ODBC Queries

Why Trust Us

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  Why ChatGPT Is So Important Today
devxblackblue

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

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
View Author
Show More