Copying database automatically then deleting data within

[irishandy]

Hello.

I am developing a database that will be used again and again on a yearly basis for the same purpose, however a fresh database will be required every time. As I see it there are two ways to go.

1) Make a copy of the existing db (which can then be archived) and then delete all data in the existing db thus retaining its structure to start anew.

2) Somehow copy the structure of the existing db into a new one, then archive the original.

In case I get asked why I couldn't just add new data to the db every time, the amount of data received each month would eventually make it just too big.

Any and all advice would be appreciated.

 

[PHV]

And what about having an always empty database to be copied when you have to create a new one ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[irishandy]

Thanks for the reply. Apologies, but I should have specified that it is likely that changes would be made to forms, reports etc... within the database and these changes would be required in the new copy too.

The plan which you suggest is already on my list as a fallback option, however it would not be ideal.