Use the ADODB object library to establish a connection, create a recordset, execute the SQL statement you want and retrieve the records. There are some pretty good examples in the VB help file. Just search for "ADODB".
Dim cnCheck As ADODB.Connection
Set cnCheck = New ADODB.Connection
Dim rsCheck As ADODB.Recordset
Set rsCheck = New ADODB.Recordset
cnCheck.CursorLocation = adUseClient
cnCheck.Open "provider = microsoft.jet.oledb.4.0;persist security info=false;data source = " & App.Path & "\MyDatabaseName.mdb"
rsCheck.Open "SELECT Field1, Field2 FROM TableNameHere WHERE Field1='foo' AND Field2='foo2'", cnCheck, adOpenDynamic, adLockPessimistic
If rsCheck.BOF = True Or rsCheck.EOF = True Then
''No records found...
txtShow.Text = rsCheck!Field1 ''Or whatever field you want.
I Developed application in C# with crystal reports and created setup file in third party (Advance) Installer.When i installed my application on client system application is working but ...