VB6 with Access 2007 database

[bahramvb]

I want to package my vb6 application, it connects to a access 2007 database and use ACEOledb provider

I use installsheild to package the software, my application in vb6 runs but I think I must add some refrences, which refrences should I add?

I added Microsoft office 12.0 Access databse engine
and removed Microsoft DAO which had conflict with the above libriary

should I add something else?

when I setup the package in XP it says Error 3706 Provider connot be found


please help me and generally what one should do for vb with access 2007 deployment

[si_the_geek]

Which references you should use depends on your code. If you untick them and compile your program, you will get an error if they are needed (if there is no error, keep them unticked).

The error you are getting means that you have not installed the ACE provider. There is a link at the bottom of my signature to download it.

[bahramvb]

thank you but as I saw the driver is 25 Mg
then I cant include that in my setup, and want the user to download and setup it sperately
doesnt it count an side effect? how many people have this driver installed?
I switched to Acess 2007 because I thought it has lesser size
now I think to back to that 2003 access db
what is actually the advantage of access 2007 to 2003

[si_the_geek]

If your program works with a database, it needs an apt Provider/Driver - and it is never safe to assume that will be pre-installed.

As to how many people will have a certain provider installed, we can only guess - but I suspect that there are far more people with Jet than ACE.

I don't know what benefits access 2007 has over 2003, I've never had a need to find out. There should be plenty of information in the help and at Microsoft.com