By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,064 Members | 1,542 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,064 IT Pros & Developers. It's quick & easy.

Connecting Access to Vb 6.0

P: 84
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.
Feb 5 '08 #1
Share this Question
Share on Google+
1 Reply


P: 68
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
Feb 5 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.