Access/SQL Server Database Explorer for VB.NET

Pramod Kumar Singh

Version Compatibility: Visual Basic.NET

More information:
Updated for VB.NET Version 1.0, 03/07/02. If you have trouble running in in IDE, try running the .exe

This application provides a detailed and excellent introduction to the new ADO.NET object model. It allows you to connect to an Access or SQL Server database, explore its structure, and run querires against it using its own Query Analyzer.

To run the application, download and extract the .zip file and Open the solution file named as DatabaseExplorer.sln.

In the case of Access, it is designed to be used for password-protected databases and requires you to identify the System Database for Access (generally in C:\Program files\Microsoft office\Office\System.mdw). When you connect to the Access database, the application reads the MSysObjects table (see the Query in Connect Method of the CAccessDatabase class), so permission to read this table must be granted to the user. In the case of SQL, login works as it does in the SQL query analyzer, except you have to identify the database you want to view in the login screen.

Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.