sudo apt-get install gambas2

Linux Desktop and Server Tutorial for Beginner
sudo apt-get install gambas2
In this tutorial, we will show you how to list all the tables in Microsoft Access using VB.NET. The idea is to list all the tables in listbox. See our example below. When the Show tables button is pressed, the program will add all the tables found on the database and add them into the ListBox. You can modify the code to suit your needs. You can freely use this code for your commercial work as well.
Here is the code:
Sub BtnshowtableClick(sender As Object, e As EventArgs)
Dim daftartabel As Data.DataTable = Nothing
Dim koneksi As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection()
koneksi.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\drilling_fe.mdb"
Dim restrictions() As String = New String(3) {}
restrictions(3) = "Table"
koneksi.Open
daftartabel = koneksi.GetSchema("Tables",restrictions)
koneksi.Close
Dim i As Integer
For i = 0 To daftartabel.Rows.Count - 1 Step i + 1
listBox1.Items.Add(daftartabel.Rows(i)(2).ToString)
Next
End Sub
Sharpdevelop is a free programming that uses Basic language similar to VB.NET. This tutorial will show you how to connect to Microsoft Access from SharpDevelop. Here is my screenshot when the program is executed, showing the connection status. This tutorial also applied to Vistual Basic.NET.
Here is my code:
Sub BtnshowtableClick(sender As Object, e As EventArgs)
Dim koneksi As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection()
koneksi.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\\drilling_fe.mdb" ‘change the directory match with your access database
koneksi.Open ‘open the connection
MsgBox ("Status Koneksi" & " :" & koneksi.State.ToString, MsgBoxStyle.Information,"Status") ‘connection status will be displayed here
koneksi.Close ‘ close the connection
End Sub