Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Empty Tables (2000)

    Is there a way of emptying the table quickly, I basically want to flush all the data out and start a fresh?
    Best Regards,

    Luke

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Empty Tables (2000)

    Take hold of a corner of the table cloth, and pull sharply. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    You can create a delete query to delete all records in a table.
    If you want to remove the records from several tables, create a delete query for each. If you wish, you can create a VBA procedure or a macro that executes the delete queries.

    Note: if you have relationships with enforced referential integrity, you must take the following into consideration:
    - If you have specified Cascade Delete Related Records for a relationship, you don't need a delete query for the table on the "many" side. When you delete records from the "one" side, the related records on the "many" side will automatically be deleted too.
    - If you have NOT specified Cascade Delete Related Records for a relationship, you must run the delete query for the table on the "many" side first, then the delete query for the table on the "one" side. The latter will fail if you try to run it first.

  3. #3
    Star Lounger
    Join Date
    Nov 2005
    Location
    Edmonton, Alberta, Canada
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Empty Tables (2000)

    I just open the table from the database window, then hit Ctrl-A and the delete key. HansV's comments about Cascaded Deletes apply to this method as well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •