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.Connection
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.OLEDB.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