• When creating read/only queries, use snapshots instead of dynasets.

• Take advantage of RDO (Remote Data Objects) available in Visual Basic 4 and Visual Basic 5.

• Remote Data Objects bypass the snapshot versus dynaset issues by sending SQL directly to the CONNX ODBC driver, without any Jet Engine processing. This results in optimum performance for Visual Basic applications that need to communicate with ODBC databases.

• Visual Basic 4 or 5 with DAO
  If using Visual Basic 4 or 5 with DAO, create the registry entry:

\Hkey_Local_Machine\Software\Microsoft\Jet\3.5\Engines\ODBC

 

In this key, add the numeric DWORD value QUERYTIMEOUT=0

• Visual Basic 4 or 5 with DAO
  Create the registry entry:

\Hkey_Local_Machine\Software\Microsoft\\Jet\3.5\Engines\ODBC

In this key, add the numeric DWORD value TRYJETAUTH=0