Connecting Access to Vb 6.0

[czi02]

Hi there:

This is just a simple question. How to connect access to vb6.0. what components should I click or references.

Would you give me an example or step by step procedure on how to connect access to database.

can you give me an examples.

[shuvo2k6]

Hi there:

This is just a simple question. How to connect access to vb6.0. what components should I click or references.

Would you give me an example or step by step procedure on how to connect access to database.

can you give me an examples.

Hi,
There are some number of procedure to connect database in VB6. Most simplest way is done by using Data object. It can also be done by ADO and RDO control. Here, I describe a simplest one by using Data object.

1. At first, u add a Data object to ur form from the ToolBar.

2. Then, set the DatabaseName property of the Data object (Data1) to ur DatabaseName.

3. Then, set RecordSource property of the Data object(Data1) to a Table of ur selected databse.

4. This is all, for connecting a MS Access Databse. In this case, must use MS Access 97 version.

5. If u want to display of the fields, then u add TextBox or Label to ur Form. Then set the DataSource property to Data1 and DataField property to a field of that selected table.

This is how, u can connect a MS Access Database to VB6 application, in fact most simple way.

Get Better.

Again,
shuvo2k6