Generate SQL Script

[Alam]

Hi,

I have altered the existing database in a new copy and created the missing
relationships and put some new fields. myquesiton is; Is there any way to
generate the alter/create table script from access? or how can I import the
amendments at existing live database.

Thankx..

Tausif

 

[Alex]

Hi,

There is no simple way of doing what you want without ether 3rd party
products, or writting code to log your database structure, showing what
has changed. I have resorted to documenting my changes in a word
document, then make the changes on the production systems out of
hours. I would love someone to correct me as I spend a lot of time
keeping my access development and production database structures in
sync.

You can use DAO/ADO to document the structure. I think only DAO will
give you indexes, but I think you will spend more time writting the
program than working on your database.

Sorry I could not answer you problem better..

Regards

Alex