Solved

Visual basic 6.0 and access XP

Posted on 2004-09-07
2
270 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
Comment Utility
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
Comment Utility
Thanks! Upgraded to SP 6 and I am off and running!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now