How would I connect my access to vb?

[czi02]

how would I connect my access in my vb?

[Reena83]

how would I connect my access in my vb?

Example:

In your Main Module: (declare general declarations)

Option Explicit
'declare global variable
Public cnnDb As New ADODB.Connectio n


Sub Main()
'change into the project directory
ChDrive Left(App.Path, 2)
ChDir Mid(App.Path, 3)

'open the database
cnnDb.Open "Provider = Microsoft.Jet.O LEDB.3.51;" _
& "Data source = Babylon.mdb"
MsgBox ("Connection is now open")

'load the main form
frmInvoiceView. Show 1

'close the database
cnnDb.Close
MsgBox ("Connection is now closed")

End Sub