Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Visual basic 6.0 and access XP

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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

604 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