?
Solved

Visual basic 6.0 and access XP

Posted on 2004-09-07
2
Medium Priority
?
286 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 1000 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
In this post we will learn different types of Android Layout and some basics of an Android App.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Progress
Suggested Courses
Course of the Month8 days, 10 hours left to enroll

764 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