Re: [MS_AccessPros] Deleting all records

 

Hi Bill,

make a blank database.  Import all the lookup tables you want to keep the data in.

Then import the rest of the tables without data. Options --> Structure Only

... and get the queries, forms, reports, macros, and modules too :)

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

________________________________
From: agent1of6

The database I have been working on is done. (until I find something else to add)  I want to put a clean copy to the test.  I have about 25+ tables with with thousands of records with many dependent relationships, making it very difficult to delete things.  Is there a way to delete all of the records in all of the tables at one time or am I going to have to do it one at a time.

Thanks,
Bill
MN

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 7
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___