Link to home
Start Free TrialLog in
Avatar of jscharpf
jscharpf

asked on

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
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

yes. you need to use an OleDBCOnnection
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
If you upgrade to service pack 4 or 5 of VB then these are required elements and will therefore be available to you.
Avatar of jscharpf
jscharpf

ASKER

thanks!

Jeff