Specific Relational Database Engines

Many vendors sell relational database products. Microsoft Access, Microsoft SQL Server, and Oracle are three of the most popular database products used by Visual Basic developers. Each provides its own assortment of database features and database management tools. The following sections provide a little more detail about these products.

Microsoft Access

Access databases are relatively simple. Each database is stored in a separate file with a .mdb extension. A Visual Basic program accesses the database directly using data access routines built in to Visual Basic libraries as shown in Figure 1.6.

Figure 1.6. Visual Basic programs interact with Access databases directly through data access routines.

Because ...

Get Visual Basic® .NET Database Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.