VC++6.0 - Problem connecting to MS-Access 2000 database

I am trying to create new DAO class (from Visual Studio classwizard) to connect to Access 2000 database.  Since MFC 6.0 uses DAO 3.5 and Access 2000 uses DAO 3.6, I did add the following line to the 'initinstance' fuction so that I can use DAO 3.6.
AfxGetModuleState()->m_dwVersion = 0x0601;

But still when I try to create a new class (using class wizard) derived from CDaoRecordset class, I get the error message saying 'unrecognized data format'. Do I have to do anything else to use Access 200 database. I did select dynamic MFC library linkage while creating the project.

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.

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
sadanand78Author Commented:
Thanks twalgrave. I tried the same. The steps work if you try to create a DAO object through your code (hardcoded). I get same error('unreocognized format') if I try to add a new DAO class through the class wizard even after following all the steps.

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

From novice to tech pro — start learning today.

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.