Loading

Ms.access to vb database connectivity

Submitted by: 


Hai

How to connect the ms. access database to vb



renz09's picture

try this code...
module code

Option Explicit
Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset

'Establish connection on database
Sub DBConnection()

Set cn = New ADODB.Connection
cn.CursorLocation = AdUseClient
cn.Open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & App.Path & "\Foldername\db.mdb"

End Sub

form load event

Call DBConnection

hope this code help you!....gud lck! HAppy Coding!

any codes for a simple library system ?

please send the coding Asp.net with ms-access database connectivity in vb coding to send my mail id [email protected]

renz09's picture

kei...I will try to sent it to you later...

Give me codng for acess and vb in which puting input through radiobuton and extractng frm database.radiobuton nd combo box

Add new comment

(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.
(If you're a human, don't change the following field)
Your first name.

Filtered HTML

  • You may insert videos with [video:URL]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.