Database Guide Visual Basic 6 VB6This Visual Basic 6 guide walks you step by step through VB6 tutorials and VB6 source code on this site that will help you learn how to develop applications that store and retrieve data from database back ends. As you read each of these database tutorials you will gain more and more knowledge in how to handle databases in your VB apps. The best way to navigate through the guide is by using the links on the left. Or you can use the links below and then hit your browsers back button. Each link will take you to a different vb. VB6 database guru. To do anything of value in Visual Basic related to databases you will first need to learn how to write SQL statements to extract what you want from your back end database. This tutorial describes how you can use ADO objects in VB6. Now days, almost any time you write full fledged database application you will want to use ADO. This applies to not only Microsoft SQL server but also to Access and Oracle databases. Learn how with this Introduction to SQL Structured Query LanguageThe data control in VB6 allows you to interact with your backend database with out having to write all the code by hand. Microsoft Windows 7 Full Activator Adjusting. This is great when you are first learning how to do database development in Visual Basic or for quick and simple VB6 database applications. For more complicated applications you will probably use ADO. RecordsetBuilder_add.png' alt='Ms Access Open Recordset For Update Oracle' title='Ms Access Open Recordset For Update Oracle' />Still check out this. Database Access with the VB6 Data Control tutorial to start getting your feet wet. This tutorial is optional as DAO is a somewhat older way of Visual Basic database development. However, if you ever have to interact with older code its good to at least understand the basics of this. Check out the Using DAO Data Access Objects Code Tutorial. Again, RDO is still not the newest and best way to access back end data. However, there is a lot of VB database code out there that uses RDO so its probably good to at least glance through this tutorial in order to know what to do if you ever work on and VB RDO project. Database Access with RDO Remote Data Objects in VB6. This is a must read Visual Basic ADO development is the newest and best way to interact with any database. After walking through this tutorial you should be able to have every tool in your belt to grab data, modify it, and write back to any database you come in contact with. Any VB6 database developer must read this Database Access With ADO in VB6 tutorial. Once you understand all the basics of how to use ADO to work with a database you will probably want to display that data to your end user in some way. One very effective way of doing this is with the list view that is built into the VB6 IDE. Using ADO and the List. View control in VB6. It is bad programming practices to write all your SQL statments directly into your Visual Basic source code. This makes it hard to change things down the road and also has a performance disadvantage compared to using stored procedures. Learn how all this works in this tutorial Using ADO and stored procedures in VB6. If you ever need to print of reports for end users you might want to consider using Crystal Reports. Although many times you can get away with writing your own reports or exporting things to Excel or Word at times this isnt an option. Check out this Using Crystal Reports with VB6 tutorial to learn more about how to create these for your end users. Optional This is optional because unless you are having to interact with an Oracle database you will never need to know this information. However if there is a time you need to use Visual Basic and Oracle together I recommend you check out this. Access and SQL Server ADP Access Data Project. Access and SQL Server can work together, ACC FE SQL BE.