Help - Database distribution

[emmzou]

I 've built an application using ADO 2.0 connected with a database created with Access 2000. When I "packaged" the project I included the files proposed by the wizard and the .mdb file. When I installed the application in a different computer which does not have Access2000 but an older version (Access97), although the installation was OK, when I tried to run the program I got the message that The Microsoft PROVIDER (I had used the Jet OleDB 4.0) was not found.
I suspect that I missed something during packaging and this may be a very primitive error but please treat me gently. I am new in this area.
Is there any other file that I should include in the installation package?

Thanks in advance

emmzou

[Clunietp]

Hi Emmzou

You must include MDAC version 2.1 or greater. This will include the Jet 4 provider

[Michael Kizer]

As a follow up to this, if you are building an installation routine to try and cover all the bases would it be ideal to have your install do the following (considering a VB 6 app that makes use of ADO, ODBC, etc.):

1)For Win 95/98-
Install dcom 95/98

2) Install MDAC (If you do the MDAC install, do you need to also do an ODBC install, or does the MDAC include the basic ODBC components?)

3) Install your app and supporting components.


As an aside... I'd been away from VB database dev for a while (say... VB 3.0) and I can see that DLL hell has gotten no better really (and probably worse). Of course I was stuck doing PowerBuilder stuff, so distributing 25MB in run time files was such a joy too. Time to start converting everything I can to a web based solution, if only to save me the headaches of installing...

[Edited by Michael Kizer on 08-14-2000 at 01:32 PM]

[emmzou]

THANKS to everybody

I included the MDAC 2.5 and everything looks fine ...so far.

Thanks

___________
emmzou