Results 1 to 5 of 5

Thread: Wipe access?

  1. Oct 23rd, 2003, 04:16 AM #1
    Bazzlad
    Bazzlad is offline

    Thread Starter
    Addicted Member Bazzlad's Avatar
    Join Date
    Jun 2003
    Posts
    227

    Wipe access?

    Is there a way inside access to wipe all data from tables?
    I mean properly so all my primary keys (Autonumbers)
    start from 0 again..
    Cheers
    *And you'll see, Everything you stand for is fake*
    http://www.rhesusrock.com
    Reply With Quote Reply With Quote
  2. Oct 23rd, 2003, 04:26 AM #2
    Buzby
    Buzby is offline
    Frenzied Member Buzby's Avatar
    Join Date
    Jan 1999
    Location
    UK
    Posts
    1,670
    Delete the rows, and then compact the database. That'll do it.
    'Buzby'
    Visual Basic Developer
    "I'm moving to Theory. Everything works there."
    Reply With Quote Reply With Quote
  3. Oct 23rd, 2003, 04:26 AM #3
    Lightning
    Lightning is offline
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611
    First truncate all tables (of you have ralationsship use delete ) then compress/ fix the DB and alle the autonumbers will start at 0
    Second possibility, make a script for all you tables, drop then and recreate them
    VB6 & C# (WCF LINQ) mostly


    If you need help with a WPF/WCF question post in the NEW WPF & WCF forum and we will try help the best we can

    My site

    My blog, couding troubles and solutions

    Free online tools
    Reply With Quote Reply With Quote
  4. Oct 23rd, 2003, 04:31 AM #4
    Bazzlad
    Bazzlad is offline

    Thread Starter
    Addicted Member Bazzlad's Avatar
    Join Date
    Jun 2003
    Posts
    227
    Cheers lads, I'll give it a whack!
    *And you'll see, Everything you stand for is fake*
    http://www.rhesusrock.com
    Reply With Quote Reply With Quote
  6. Oct 23rd, 2003, 04:34 AM #5
    Bazzlad
    Bazzlad is offline

    Thread Starter
    Addicted Member Bazzlad's Avatar
    Join Date
    Jun 2003
    Posts
    227
    That's worked great, cheers again!
    *And you'll see, Everything you stand for is fake*
    http://www.rhesusrock.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width