Copy Database

[livvie]

I need to copy a database without the data. I need to hold the keys and relationships etc. I also need to be be able to copy Views and queries ?

 

[hymn]

Create a new db then imort your old db in the OPTIONS for the table just definition not data

Hope this helps
Hymn

 

[livvie]

This doesn't import the keys relationships etc

 

[hymn]

What version are you using 2002 you can tick a box for relationships under import

Hope this helps
Hymn

 

[livvie]

I saw that box alright but it's greyed out only the Menu and Toolbars one is available.

 

[hymn]

Sorry I'm going to have to pass now the only other way I know is manual

Hope this helps
Hymn