clear database

[Tom]

Hi all,
I created DB with tables, forms etc...
now, this DB is use, I want to clear the data and keep all the programming.
basiclly, make it as new - was never used.
I was wondering if creating a new DB and import all the components will do
the work or is there a better way?
Should I build everything again from scratch?

Thanks,
Tom

 

[Brendan Reynolds]

When importing tables, there is an option to import structure only, or
structure and data. Importing structure only will do the job for you.

There are a few things that you have to re-do when you import into a new
database, like setting the title, startup form, custom icon if you're using
one, etc. Whether it's faster to do the import and reset those properties,
or create a delete query for each table, will depend on the specifics - how
many custom properties you're actually using, etc.

If you delete the data from the existing database, don't forget to compact
afterwards.

 

[Tom]

Thanks for the quick advice

When importing tables, there is an option to import structure only, or
structure and data. Importing structure only will do the job for you.

There are a few things that you have to re-do when you import into a new
database, like setting the title, startup form, custom icon if you're using
one, etc. Whether it's faster to do the import and reset those properties,
or create a delete query for each table, will depend on the specifics - how
many custom properties you're actually using, etc.

If you delete the data from the existing database, don't forget to compact
afterwards.