In the Control Panel under Administrative Tools in Windows 2000, Data Sources (ODBC) how do I connect my Microsoft Access database? Also in VB 6.0 in my Module how do I code the connection? I know how in Windows 98 and using ADODB. See below.Public Sub open_access()
Set Delaine= New ADODB.Connection
Delaine.Provider = “Microsoft OLE DB Provider.ODBC;Persist Security Info=False;”
Delaine.ConnectionString = “Data Source = ” & App.Path & “\CricketWorks.mdb”
End Sub
Please help me.