Visual Basic Sql Select Count MS Access Tutorial OLEDB

In this visual basic tutorial, we will select the number of records from MS Access using visual basic code sample below.

Visual Basic SQL Select Count Code

Dim constr As String
constr =  "Provider=Data Source=yourmdbfile.mdb;provider=Microsoft.Jet.OLEDB.4.0";

Dim str_select As String
str_select = "SELECT COUNT(*) FROM tbl_users"

Dim ds As DataSet
Dim da As System.Data.OleDb.OleDbDataAdapter
Dim con As System.Data.OleDb.OleDbConnection 

con = New System.Data.OleDb.OleDbConnection(constr)
da = New System.Data.OleDb.OleDbDataAdapter(str_select, con)
ds = New System.Data.DataSet()

da.Fill(ds)
        

Note that you can also use this sql select count code sample in ASP.NET Visual basic with MS Access oledb.