How to connect a database? - TechRepublic
General discussion
July 30, 2001 at 07:36 AM
msdelaine

How to connect a database?

by msdelaine . Updated 24 years, 11 months ago

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.

This discussion is locked

All Comments