I need a solution to access query created in MS Access using Visual basic 6.0.

Request you to please provide me the VB code for the same.

Many thanks in advance.

Regards,

Raja

raja_980@rediffmail.com

Regards,

Raja



raja_980@rediffmail.com

check this it works.

Query is the Name of the MS Access Query

Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub Form_Load()
rs.CursorLocation = adUseClient
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\BACKUP.mdb;Persist Security Info=False"
con.Open
rs.Open "Query", con, adOpenKeyset, adLockOptimistic

End Sub


IAMS

The initiative taken for the concern is very serious and need an attention of every one. This is the concern which exists in the society and needs to be eliminated from the society as soon as possible.

=====================================

Chinese Translation

kinoshika