• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Does VB6 work with Access 2002 ?

Do I have to use VB.NET to work with an Access 2002 (is this the same as Office XP?)  database? I currently have VB 6.

THanks

Jeff
0
jscharpf
Asked:
jscharpf
  • 2
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
yes. you need to use an OleDBCOnnection
0
 
Éric MoreauSenior .Net ConsultantCommented:
Sorry. Using VB6, you can use Access 2002 database if you are using the ADO Jet 4.0 provider.
0
 
TimCotteeHead of Software ServicesCommented:
Indeed emoreau is correct, either use ADO Jet 4.0 provider or use DAO 3.6 rather than 3.51 or earlier. The access 2002 (Office XP it is) and Access 2000 both require you to use MDAC 2.1 or higher which includes the 4.0 jet provider (MDAC 2.6 and higher does not ship the jet engine though it is available seperately) or to use DAO library version 3.6 or higher.
0
 
TimCotteeHead of Software ServicesCommented:
If you upgrade to service pack 4 or 5 of VB then these are required elements and will therefore be available to you.
0
 
jscharpfAuthor Commented:
thanks!

Jeff
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now