Package with access

[alexanderjames]

Hi All

I was just wandering, i have written a program for some colleagues of mine, the program uses an access db, so what i was wandering was do i have to install access on the p.c's that are using my prog or is there a way to include it in the package and deployment wizard.

Many thanks

[danasegarane]

There is no need that the client system to have access installed.How to connect the access database?

[pnish]

The P & D Wizard should automatically include any dependencies you need, ie DAO or ADO depending on what your code uses.

[RobDog888]

Also dont forget to add the database to your package as well.


Moved

[alexanderjames]

Hi All

Thank you for your replies, i installed my prog on a p.c without access and i got a system error, the moment i installed ms access it worked beautifully, the .mdb is on the p.c in the correct path and i connect to the db with ado. Am i missing something in the p & d wizard perhaps.

Many thanks

[RobDog888]

All you need to support Access without having Access installed is to have MDAC in your package. Do you have a reference to Microsoft ActiveX 2.x Data Objects library?

[ganeshmoorthy]

and could you post the error what you got in the other pc...

[alexanderjames]

Hi Robdog

Yes i have a referance to the microsoft active x 2.5 library, should i change it to the 2.8, i also read that i should install the vb6 runtime environment add on. Any ideas?

Many thanks

[RobDog888]

When you create a package using the P&D Wiz it will automatically pickup the MDAC reference and add it. If your system is running 2.8 then your apps reference for MDAC should package 2.8 to install on the client machine if they dont have that exact version.