VB5.0 does not recognise Access 2000

I have an application written in VB5.0 that interogates and updates an Access 97 MDB file. It works fine. I have now upgraded to Access 2000 and the VB frontend returns a message "Unregognised database format error 3343". What do I have to do to make the VB code recognise the 2000 database? Is there something that must be loaded? I guess it is the change to the new Jet engine. What are the implications if I want to use the MSDE engine?
cdvAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

caraf_gCommented:
Yes, you'll have to use the updated DAO dll. I think it is DAO360.dll

Microsoft DAO 3.6 Object Library
0
nutwissCommented:
You can download the latest version of MDAC_TYP from:

http://www.microsoft.com/data/download_21242023.htm
0
marcj1Commented:
I've not worked with Access 97 to 2000 conversions however, historically (Access 2 to 95 and 95 to 97) MS provided a compatability library, e.g. "Microsoft DAO 2.5/3.0 Compatibility Library" or "Microsoft DAO 2.5/3.51 Compatibility Library".  This allowed the developer to use an upgraded version of Access while maintaining code based on a previous version's object model.  If you have access to the MS Office 2000 Resource Kit, you might want to see if this this library is included.  Good luck!
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

lbowersCommented:
Caraf is right - You'll need to use the Jet 3.6 engine. It can open Access 97 and Access 2000 databases. Data controls aren't fully Access 2000 compliant yet though.
0
ivancCommented:
CDV

I think the current version of the MDAC_Typ provides Jet 4.0 which is compatible to both ACcess 97 and 2000

Ivanc
0
cdvAuthor Commented:
Thanks to all. I think you are all on the right track. Problem is I can't get it to work. This is what I have done:

Ran DCOM98.EXE to load V1.3.

Installed MDAC 2.1.24203 by running MDAC_typ.exe.

Copied DAO360.DLL to PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO

Ran REGSVR32.EXE DAO360.DLL. I got a successfully registered message.

I still get the same unrecognised database message. Is there something I should be doing in my VB program to get it to look at the new DLL?

Help for an extra 100 points!!
0
marcj1Commented:
From the project menu, choose references, VB will present a list of friendly names for the libraries registered on your PC.  Choose the one that corresponds with this version of DAO (it'll be the highest versioned one) and choose OK.  If you don't see the new library on the list, browse to where you copied dao360.dll and choose it.  Happy hunting!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cdvAuthor Commented:
Thanks. This is the bit that I was missing. It now works 100%. My problem has been solved by the first answer that pointed me to DAO36 and now your answer on how to activate it. Ideally you should share the points
0
caraf_gCommented:
I don't mind, marcj1 gave you a lot of help, so the points are well deserved.

If you do insist you want to give me some points, you can always post a "dummy" question. "X Points for caraf_g"

Thanks

Pino
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.