How do I check whether I am using Jet4 to access the database

I have a VB6 SP6  program that interacts with an Access97 database, and it works perfectly.  I just converted the database to Access 2002, and now the VB6 program returns run-time error 3343, Unrecognized database format.

After reviewing some solutions here, I gather that I need to use Jet4 engine as one of the references in VB6 application.

However, I do not find Jet4 listed in the list of references. Where can I find it? If it is not there, can I add it? How?

What is PDW? How can I use it to package my application?

Thanks,
Raheel
RaheelShahAsked:
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.

Ryan ChongSoftware Team LeadCommented:
>>However, I do not find Jet4 listed in the list of references. Where can I find it? If it is not there, can I add it? How?
try:

Open the References Window, then click the Browse button, then go to:

C:\Program Files\Common Files\System\ado

then select the msado2x.tlb available.

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
Ryan ChongSoftware Team LeadCommented:
You can also install the MDAC if it's not available in your pc:

http://msdn.microsoft.com/data/mdac/downloads/default.aspx
pradapkumarCommented:
PDW 's expansion is Package and Deployment Wizard.
That will automatically add all the dependecy files used by your application.
There is no need of explicitly mention your MDAC file. You can use the mdac file which is available in above link location.
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

RaheelShahAuthor Commented:
Hi!

About PDW, how do I install this wizard? Does it come with VB6? It is a separate application I run to bundle up my application?

Thanks for the help!
Raheel
pradapkumarCommented:
It will be installed if you installed Visual Studio Enterprise edition.
To reach PDW first open ur project then goto Add-Ins -> Add-In manager
in the displayed dialog box select PDW and check 'Load on startup' and 'Loaded/Unloaded' options.
then click on OK button.
then again goto Add-Ins menu at there you can see PDW menu item.
click that and follow the instruction provided by the wizard.

thats all.
If PDW not available try to install using your VS6 Installation CD
RaheelShahAuthor Commented:
Thanks Kumar!

You have been a great help! Actually, The MDAC didn't solve my initial problem. I am using Data Access Objects (DAO) (or the DAO generic Data Control) in my application. I am still getting unrecognized format error.

I will enter a new post asking for further help.

Thanks,
Raheel
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.