VB.NET - how to connect VB with MS access - Asked By jeccinta jeccinta on 07-Mar-06 03:02 AM

hi,
 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.
[CODE]
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"

adoconnection.Open connectstring
rs.ActiveConnection = adoconnection
rs.Source= "Select * From TableName"
rs.CursorLocation=2
rs.LockType=2
rs.CursorType = 0
rs.open
[/CODE]

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)
MyDatabase.Open()

h - vanka chandu replied to jeccinta jeccinta on 17-Aug-07 05:06 AM

koti na kodaka
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