A way to clear the tables in the database...

[jjh]

Hi:
Thanks for considering my question. I have developed a DB with about 60 tables, all related by one-to-many relationships. During development, I placed values in the tables, generated keys, etc. so things have gotten quite cluttered. Is there a way (vb program, access method, etc.) that I can use to remove all the entries from the table, and essentially start with a set of clean tables and no keys? I'd like to be able to run this from a control on a form. Any help is appreciated.
Thanks
JJH

 

[Banana]

What about creating a blank database and importing all the tables you need. Clear the box "Import Relationship".

That'll do the job.

PS. 60 tables? Are you sure it's properly normalized?

 

[jjh]

followup

Hi:
Thanks for your suggestion. Well, I have a 'developers form' that I am adding certain methods to, to do things on the database. For example, change the way certain controls work, import things in certain ways, etc. I want to stay in developers mode and try things, and not always have to go through what you suggested.
Yes, the tables are normalized. This is part of a larger project to capture software and hardware architectures via a language, and I am imitating many parts of the language in the tables. Yes, It is normalized.
thanks
John