VB.NET - how to connect VB with MS access - Asked By jeccinta jeccinta on 07-Mar-06 03:02 AM
I need the steps to connect VB with MS access database......
am very new to VB........
very very urgent.......
how to connect VB with MS access - Asked By Pankaj Sharma on 07-Mar-06 03:31 AM
Code to connect and get the data into record set.
Dim adoconnection As ADODB.Connection
Dim rs As ADODB.Recordset
Dim connectstring As String
Set adoconnection = New ADODB.Connection
Set rs = New ADODB.Recordset
connectstring = "provider=microsoft.jet.oledb.3.51;" _
& "data source=L:\vbInventory\inventory.mdb"
rs.ActiveConnection = adoconnection
rs.Source= "Select * From TableName"
rs.CursorType = 0
Try This - Asked By R J on 07-Mar-06 04:07 PM
Dim MyDatabase As OleDb.OleDbConnection
Dim ConnectToMyDatabase As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=<PATH to database, such as C:\Program Files\Database.mdb>"
MyDatabase = New OleDb.OleDbConnection(ConnectToMyDatabase)
h - vanka chandu replied to jeccinta jeccinta on 17-Aug-07 05:06 AM
how to connect VB with MS access - poonam rana replied to jeccinta jeccinta on 25-Jul-08 12:08 PM
how to connect VB with MS access
Need help - parishith p replied to jeccinta jeccinta on 01-Apr-09 02:18 AM
How to connect database with VB.NET, MS Access
function connect to Access - samnang nguon replied to jeccinta jeccinta on 28-Jan-10 04:04 AM
hi ! me just study this programe so me want to know about function connect to Access