Solved

Visual basic 6.0 and access XP

Posted on 2004-09-07
2
280 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
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A short article about a problem I had getting the GPS LocationListener working.
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 fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

856 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