Microsoft Visual Basic 6 provides tools and components for building database client applications. But rather than building an entire application to test your SQL, VB6 includes a Visual Database Manager that can be used to directly test and execute SQL statements. To use the Visual Database Manager do the following:
Microsoft Visual Basic uses ODBC (and DAO) for database integration. To interact with ODBC, an ODBC Data Source must be present before proceeding (see the earlier instructions).
Launch the Visual Basic Development Environment.
Select Visual Database Manager from the Add-Ins menu.
From the File menu, select Open Database and then select ODBC.
Select the ODBC Data Source to connect to. You might be prompted ...