Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2008
    Posts
    2

    Question Unanswered: Delete all data from db to start over

    I need to erase all the data entered into a Access DB that was entered in years ago so I can use the db now with new data. We are using it to track company inventory and projects. The db has many interlinked tables. I want to delete all the data but leave the tables, forms etc in place as a "template" so I can create and use the db with current data.

    Is there an easy way to do this???

    Heather

  2. #2
    Join Date
    Aug 2006
    Posts
    559
    Ms. Heather,

    Take a look in the code bank, I think there is a db in there that will allow you to delete all the 'test' data that is entered into a db without touching the structure and anything else.

    I have it, I'll try to find it. If I do, I'll zip it and post it here.

  3. #3
    Join Date
    Oct 2008
    Posts
    2

    Unable to find code

    I wasn't able to find the code you mentioned. If you do have it and can send it over that would be great thanks!!!!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'd say it's a matter of opening each table and deleting the unwanted data manually. How many tables are there?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Try creating a new mdb and import all the objects but when it comes to tables, select the Options button and then import Definition only (no data.) (Make sure relationships is checked.) Make sure to debug->compile the code after importing.
    Last edited by pkstormy; 10-07-08 at 22:49.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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