Accessing Query created in MS Access using visual basic 6.0


Home : Code : Forums : Submit : Mailing List : About : Contact

A1VBCode Forums

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

Accessing Query created in MS Access using...

Rate Topic

Display Mode

Topic Options

Author

Message

raja_980

Posted 6/25/2010 2:28:19 AM

Forum Newbie

Group: Forum Members
Last Login: 7/12/2010 9:28:37 PM
Posts: 1, Visits: 12

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

Post #29373

iams

Posted 7/20/2010 2:39:52 AM

Forum Newbie

Group: Forum Members
Last Login: 7/27/2010 7:50:56 AM
Posts: 1, Visits: 2

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

Post #29450

kinoshika

Posted 11/29/2010 1:55:56 AM

Forum Newbie

Group: Forum Members
Last Login: 11/29/2010 1:52:42 AM
Posts: 1, Visits: 1

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

Post #29822

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 1 (1 guest, 0 members, 0 anonymous members)

No members currently viewing this topic.

Forum Moderators: Admin, Mod, Mark, Keithuk

Permissions

All times are GMT -5:00, Time now is 2:08pm