Small help in VB

[shariefoo]

HI all,

I am creating the project in VB and i am using Access as my Database.

I have a small question

How can i get the data from access to show them in my VB form without using ODBC ?

Is there a way i could do that ?

Please help ?

Thanx

 

[shariefoo]

Sorry i forgot to add this..

I was told that there is a code using SQL command to do so ? I searched hard and was not able to get it..

 

[hi there]

search for "ADO connection." using ADO you can provide ODBC or OLEDB providers to establish connections to your front end objects. have this code run on a OnClick event associated with a command button. typically, you want to provide some criteria before pushing an entire table's recordset across the network. it's best to use a query to generate your form's recordset. so create a query on the backend and use ADO in your forms module to create a connection to the backend recordsource. alternatively, you can use define your SQL statement in your forms module instead of using a query, but i believe it's faster to use a backend query.

hope that helps