[RESOLVED] Add tables/queries to an existing database

[VBFnewcomer]

Morning everybody,
Assume a database was sent to user as a part of project setup duly made using PDW. I would like to know if it is possible to add one or more tables/queries to the existing database through a fresh setup using PDW. While updating the db the data already in use with the customer should not be overwritten.
DB: Access 2003
VB6

Thanks in advance

[randem]

I believe that when deploying a new file that PDW will overwrite the old file. I don't believe that in PDW you can specify anything other than that.

[VBFnewcomer]

I don't believe that in PDW you can specify anything other than that.

Can inno perform such kind of acts. Or is there a way to add tables/queries into an existing db without destroying the existing data

[randem]

You can't deploy new tables or queries like that. What you can do is to deploy another database that has the tables and queries in them and then use code to update the database with the new tables and queries.

In Inno Setup you can specify to overwrite the database or to leave it alone. You have the option on deployment.

[VBFnewcomer]

What you can do is to deploy another table that has the tables and queries in them and then use code to update the database with the new tables and queries

or simply make a setup of the EXE with code something like create table/View on app startup to create a table/queries/views.
Is this possible?

[randem]

Yes, you can deploy an exe to alter the table structures and create new queries.

[VBFnewcomer]

Thanks very much randem