How to include DB in Package & Deploy?

[jandrade15]

Hello Everyone- Im new with Vb 6.0. I mainly use access 2002 but now I need to convert my program to be able to distribute. Im having a hardtime including tables from this database. How do I make a copy or a new table that can be packaged with the deployment wizard? What I mean is how can I make a access table so that the database im creating with VB will be able to be packaged & delpoyed on another PC? Hope this doesnt sound confusing. Thanks for all your help in advanced! :confused:

[randem]

jandrade15,

I would suggest leaving PDW and using ********** (http://www.**********.html/**********.html) and Inno Setup (http://www.jrsoftware.org).

BTW, you do not include a table. You include the whole database which contains the table.

[RobDog888]

If you use the P&D Wiz, you can add extra files to the package in this step
by clicking on the add button and changing the browse filter to all files so
you can see your *.mdb database.

[jandrade15]

Thanks Guys, it worked. The only problem im having is that where would I put the database. for instance, when i add the database on the PDW it keeps the address where i have the database now. How do i put a generic address so that when someone else installs it it finds the database and doesnt get an error on it? Thanks for all your responses!!!

[RobDog888]

When your at the step where you see the Install Locations, select your
database by selecting it in the left most or first column. Then scroll to the
right to see the column that says "Install Location". Click into it. You cant
click into it unless the item it selected first. Then a combo will appear. Click
the dropdown to show a list of macro paths (app.path, program files, etc.).


HTH

[jandrade15]

Thanks a Million your a Genius oops....."GURU!!" Thanks man! :wave:

[RobDog888]

No prob. Glad to help. :thumb:

[Habibi]

RobDog888

Great and helpfull tutorial. Learnt new things, thanks mate.
Habibalby

[RobDog888]

Watch this Forum for my upcoming tutorial on the P&D Wizard. :)