A database is similar to a data file in that it is a storage place for data. Like a data file, a database does not present information directly to a user; the user runs an application that accesses data from the database and presents it to the user in an understandable format. In a well-designed database, there are no duplicate pieces of data that the user or application has to update at the same time. Related pieces of data are grouped together in a single structure or record, and relationships can be defined between these structures and records. There are different ways to organize data in a database but relational databases are one of the most effective. Relational database systems are an application of mathematical set theory to the problem of effectively organizing data. In a relational database, data is collected into tables.
This section contains simple and complex VB Database Projects.

Zip	Description	Author	Versioin	Level	Site	Date
	Ado Data Sort Control will display your data from database, filter, sort (up to 3 levels) all in HFlexGrid.	Dugi	VB 6.0	Intermediate	Home	1997
	Simple application that shows how to use the Data Control to connect to the Biblio.mdb database and display all authors in the Authors table.	George Tsang	VB 5.0	Beginner	n/a	1999
	An excellent SQL Query tool for SQL Server or Oracle. Rating:	Remus Bodean	VB 6.0	Advanced	n/a	1997
	This program generates a dynamic datareport during runtime without using any DataEnvironment object. It is passing the datasource and recordset properties during run time.	Prakash	VB 6.0	Intermediate	Home	2000
	Database explorer for viewing all tables and queries in a database. Also includes an SQL editor similar to SQL Query Analyzer.	S. P. Rathugama	VB 6.0	Intermediate	n/a	2001
	Application which searches an Access database for a specified search term entered by the user.	Shahid Majed	VB 6.0	Beginner	n/a	2000
	This code shows you how to display information from a database in a chart using the MSChart control. A number of features of this control are illustrated.	Umesh Dwivedi	VB 6.0	Intermediate	n/a	2000
	This is a complete application that shows you how to load images from a database to a picturebox using the ADO GetChunk method, and how to save images to a database using AppendChunk.	D. Nishimoto	VB 6.0	Intermediate	Home	2000
	An example of appending an Excel worksheet to an Access database.	Herman Liu	VB 6.0	Beginner	n/a	1998
	This is basically an implementation of Enterprise manager in Visual Basic, though it does not contain the entire feature set. However, it allows you to connect to a specified SQL Server and database and view all tables and columns in a treeview, and all the data in a grid control. It also displays objects such as stored procedures, views, foreign keys, etc. You can also use the application to run queries and administer the database.	Srdjan	VB 6.0	Advanced	n/a	2000
	This application allows you to open a database and view each table and field in the database, as well as the contents of each table in a grid. You can also add data, tables, and fields (though does not permit you to to specify the new field's type or size). A good demo of DAO, data controls, and data grids for beginners.	Ali Ezzahir	VB 6.0	Beginner	Home	1999
	The application includes a Data Report and uses the Data Environment, so it is a good example if you want to learn how to use these. It requires ADO 2.5 and the JET OLE.DB 4.0 provider.	Eric Morrison	VB 6.0	Intermediate	n/a	1998
	This applications illustrates how to use the ADO Schema to obtain a list of tables of a database, possible techniques to enable opening several tables on the screen in the same session (using the same form) yet without conflict, how to display various attributes/properties in human readable text, as opposed to VB's original numeric codes. Rating:	Herman Liu	VB 6.0	Advanced	Home	2000
	Take the advantage of learning ADODB and the datagrid control in a MdiForm with the capability of doing; addnew, delete, edit and search.	WolFSON	VB 6.0	Intermediate	n/a	2000
	How to load a ComboBox with data tables and link that to another ComboBox containing fields. Also demonstrates the GetOpenFileName API function - selecting a filename without using the Common Dialog control.	Matt Hart	VB 6.0	Beginner	Home	1999
	You can use this progam to import ASCII text files in any format into Microsoft Access. This looks much like Microsoft DTS wizard.	R. Gardner	VB 6.0	Beginner	n/a	1998
	This project uses ADO 2.1 to open, view - edit Access, SQL server, DSN and Oracle databases. There are also a few features to let you add, rename and delete tables as well as purge based on a Date/Time field. Clearly not a replacement for Access, but you can distribute it to help troubleshoot. Automatically registers itself as the default database viewer for .mdb files on systems without a default already set. Otherwise, it becomes a second option when right-clicking. Its Biggest advantage is its all ADO. Rating:	Paul Mather	VB 6.0	Advanced	n/a	1999
	This is an ADO Recordset demonstration project writen by James Allen Bressem in Jan. 2001. This project shows how to use ado methods to do a few usefull things such as: 1. Output an ADO recordset to an html table. 2. Output an ADO recordset to an XML file. 3. Output an ADO recordset to a dat file and reload it. 4. Output an ADO recordset to comma delimited file. 5. Output an ADO recordset to Table delimited file.	Sean Street	VB 6.0	Intermediate	Home	2001
	This is a very simple application demonstrating the steps taken to convert a MS Access database to an XML file. Great tool for learning XML.	Yu Wu	VB 6.0	Beginner	n/a	2000
	This simple project is for beginners who need to know how to use the data report and data environment. The project will also teach simple ADO operations such as add, modify, delete.	V. Rameshbabu	VB 6.0	Intermediate	n/a	2000