1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Clearing an Access database?

Discussion in 'Business Applications' started by subnet_rx, Feb 12, 2005.

Thread Status:
Not open for further replies.
Advertisement
  1. subnet_rx

    subnet_rx Thread Starter

    Joined:
    Oct 15, 2004
    Messages:
    168
    Is there an easy way to keep the structure but clear all data out of an Access database?
     
  2. ransford

    ransford

    Joined:
    Mar 16, 2001
    Messages:
    76
    How many tables in the database?
     
  3. slurpee55

    slurpee55

    Joined:
    Oct 20, 2004
    Messages:
    7,837
    Only 2 come to mind, both easy in a simple database and both a pain in a very complex one. For each table, you can copy and paste the table, saving the structure in the pasted table. If you wish, rename or delete the old table and name the new one with the old name - this will keep all queries, forms, etc valid.
    The other way would be to open up each table, highlight all the data and delete it. I am no guru - there may be a faster way, though.
     
  4. coachdan32

    coachdan32

    Joined:
    Nov 13, 2003
    Messages:
    1,021
    Make sure to make a backup first. I am assuming you have relationships and cascading updates/deletes setup. I always remove the relationships, delete the data from the tables - then set the relationships back up the way they were.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/329705

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice