truncating tables in MS Access

DeebaserDeebaser on my way to work in a suit and a tieAhhhh...come on fucking guyRegistered User regular
edited June 2010 in Help / Advice Forum
I'm having a major brainfart this morning. I've created an mdb file with step by step queries that are so easy a caveman could do it. The only problem is that Im starting with appending a null table (lets call it table1) and when I finish table1 is still all populated with data and shit.


How can I clear out the data in table1 using a query as I don't trust these mouth breathers to manually delete the entries in table1 and I can't be assed to run this report on demand?

Deebaser on

Posts

  • yurnamehereyurnamehere Registered User regular
    edited June 2010
    "DELETE FROM table1" should work, though it logs each individual record deletion.

    EDIT: And also does not reset auto-incrementing fields, if that is an issue.

    yurnamehere on
Sign In or Register to comment.