Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    15

    Unanswered: Resetting Database?

    Is it possible to remove all of the data from your database and just leave the structure? I would prefer if all of the autonumbers began at 1 again and it was just like starting from scratch.

    Thanks

  2. #2
    Join Date
    Mar 2005
    Location
    Phoenix AZ
    Posts
    56
    I don't know of a way to do a mass update, but if you copy a table and then paste the table into the database, it gives you the option of pasting just the structure. That would create an identical table to your original but with no data and your AutoNumber would begin at 1.

  3. #3
    Join Date
    Aug 2008
    Posts
    15
    Perfect Thanks RDB thats just what I was looking for.

  4. #4
    Join Date
    Sep 2007
    Location
    Global Village
    Posts
    185
    If you do compact & repair with no data in your tables auto numbers will be reset as well without copy and past structure.
    <<Never Walk on the Traveled Path, Because it only Leads you to where the Others have been.>>
    Graham Bell

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Agreed with Aran1. Just empty the tables and then C&R and you're done.
    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

Posting Permissions

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