You are currently offline, waiting for your internet to reconnect

How To Create an Access Database Through Visual Basic 4.0

This article was previously published under Q150418
This article describes how to create an Access database programmaticallywith a code example. The code is useful if you need a database with aspecific number of fields and records for testing purposes.
An Access database called TEST.MDB is created when you click the commandbutton. In this example, the database contains 55 records with each recordcontaining 40 integer fields. By changing some of the code, you alter thenumber of records and fields and the contents of the records.

In the Form_Load event, the code checks to see if the database exists. Ifthe database does not exist, a command button is shown on the form.Clicking the command button creates the database.

Code Example

  1. Start Visual Basic 4.0. If it is already running, from the File menu, click New Project.
  2. Add a command button, data control, and a DBGrid control on Form1. Set the DataSource property of the DBGrid control to the Data control.
  3. Copy the following code sample to the Form1 code window:
          Option Explicit      Dim rs1 As Recordset      Dim rs2 As Recordset      Dim db As Database      Dim td As TableDef      Dim fl As Field      Private Sub Command1_Click()         Dim iFields As Integer, iRecords As Integer         ' Create the database.         Set db = CreateDatabase("C:\test.mdb", dbLangGeneral)         Set td = db.CreateTableDef("Table1")         'Now that the database is created, add fields to the database         For iFields = 1 To 5 'The last number can be changed.            Set fl = td.CreateField("Field " & CStr(iFields), dbInteger)            td.Fields.Append fl         Next iFields         db.TableDefs.Append td         ' Now that the database has fields, add records through a         ' recordset.         Set rs1 = db.OpenRecordset("Table1", dbOpenTable)         For iRecords = 1 To 10  ' For each row            rs1.AddNew           ' add a new record.            For iFields = 1 To 5      ' For each field in the record               rs1("Field " & CStr(iFields)) = iFields  ' add a number.            Next iFields            rs1.Update         Next iRecords         ' Close both the recordset and database.         rs1.Close         db.Close         ' Populate the DBGrid control with the contents of the Recordset.         Set db = OpenDatabase("C:\test.mdb")         Set rs1 = db.OpenRecordset("Select * from Table1")         Set Data1.Recordset = rs1         Command1.Visible = False      End Sub      Private Sub Form_Load()         If Dir("C:\test.mdb") = "" Then            Command1.Caption = "Create Database"            Command1.Visible = True         End If      End Sub						
  4. Press the F5 key, or click Start on the Run menu to run the program. Click the Command button, and populate the DBGrid control. Note that the file TEST.MDB is also created.
4.00 vb4win vb4all

Article ID: 150418 - Last Review: 06/28/2004 15:16:00 - Revision: 3.0

Microsoft Visual Basic 4.0 Professional Edition, Microsoft Visual Basic 4.0 Professional Edition, Microsoft Visual Basic 4.0 16-bit Enterprise Edition, Microsoft Visual Basic 4.0 32-Bit Enterprise Edition

  • kbcode KB150418