Ms.access to vb database connectivity

Submitted by: 


How to connect the ms. access database to vb

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 with ms-access database connectivity in vb coding to send my mail id [email protected]

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

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • 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.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.