Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How can I delete rows from all tables? (Access2003)

    Is there anything like a "truncate database" command for Access, as in Oracle? I am looking to reinitialize a database by globally deleting all rows from all tables and leaving the structure intact.

    Thanks Much!

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

    Re: How can I delete rows from all tables? (Access2003)

    One way is to import all database objects into a new blank database. The Import dialog has an Options >> button; if you click it, you can specify that you only want to import the definition of the tables, not the data. You will have to set startup options anew, as well as non-standard VBA references.

    Trying to clear all tables within (a copy of) the database itself can be tricky, depending on the way relationships have been set up.

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How can I delete rows from all tables? (Access2003)

    Thanks! I'll do it that way..

Posting Permissions

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