Reply to thread

Message: <blockquote data-quote="GTRZ" data-source="post: 1192981" data-attributes="member: 1">conenct Access db from Visual Basic or from what?If its from Visual BasicOption Explicit'declare global variablePublic cnnDb As New ADODB.ConnectionPublic varInvNo As Long 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 = dbname.mdb"    MsgBox ("Connection is now open")        'load the main form    frmInvoicesView.Show 1        'close the database    cnnDb.Close    MsgBox ("Connection is now closed")    End Sub</blockquote>

Top Bottom