Copy tables between databases

[jurgen]

We've created a database in development, now the database is ready for production, how can we copy the tables from one database to another without ot with the data in it, the client site is an MS access 2000 adp/ade project.

We've tried several ways, but I think that we do it wrong, we lose everytime the primary keys the relations etc ...

Can someone helps us to migrate the database to production and not have to manual create everything again by hand ...

Regards and thanx

Jurgen

 

[Bernadette]

Hi Jurgen

You cound use the DTS Wizard to to this as it will copy the tables with or without the data.

Hope this helps
Bernadette X-)

 

[jurgen]

Thanx

You did it ... it works the exact way we want


Jurgen

 

[Bernadette]

Excellent !!!!
I am really glad it worked

Bernadette X-)