[RESOLVED] Linking Access databases with DAO

[Osprey]

I need some help to deploy my VB6 application working with Access databases. I want the user to have the possibility to install the program and the databases in any directory. How do I direct the links in the DAO to the databases before exporting? Do you recommend to use the internal packing wizard, or is it better to use another?

[dglienna]

Inno Script and Inno Setup let you deploy where you want, plus includes the options for desktop icons and Quick Launch shortcuts automatically.

You can use APP.PATH to get the folder that they have installed into, or append any other folders to it. APP.PATH & "\Databases\"

[RobDog888]

You could set your DAO OpenDatabase argument to something like dglienna posted using the App.Path & "\YourDBName.mdb". There is no need to recreate everything in another installer program as this issue is a programming issue and not a packaging problem.

[Osprey]

Thanks for your advice. I hope I will manage to link them the way they should with the method described.