Solved

Visual basic 6.0 and access XP

Posted on 2004-09-07
2
283 Views
Last Modified: 2012-05-05
I am trying to pull data from an Acess XP database using VB 6.0, is there a refrence i need to add to my project to make this work?

-THX, Drew
0
Comment
Question by:Drew_Mora
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 250 total points
ID: 12001331
Hi Drew_Mora,

Yes there is. You either need to use DAO (version 3.6 or higher) or ADO (version 2.1 or higher) and then the appropriate connection/recordset etc.

If you are using built-in controls such as the data control then you either need to use the ADODC control instead or install Service Pack 4 or higher for VB to upgrade the built-in controls so that they are compatible with access 2000 and upwards.

Without knowing any more information it is a little difficult to be more precise than this but it may help to get you started on solving your problem.

Tim Cottee
Brainbench MVP for Visual Basic
http://www.brainbench.com
0
 

Author Comment

by:Drew_Mora
ID: 12001561
Thanks! Upgraded to SP 6 and I am off and running!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show, step by step, how to integrate R code into a R Sweave document
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question