Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deleting Records (VB ver6)

    Hi,

    How to delete all the records in a table? Thanks...

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Deleting Records (VB ver6)

    Are you using ADO to access a database table? Are you editing a table in a Word document? More info please...

  3. #3
    New Lounger
    Join Date
    Feb 2003
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deleting Records (VB ver6)

    I'm using ADO to access a database table. Only managed to delete by record. Try to delete all the records in the table. Thanks...

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Deleting Records (VB ver6)

    To delete all records from a table, set the CommandText for your ADO Command object to something like this:

    DELETE * FROM MyTable

    Just in case I'm completely out to lunch, I'm moving this to the Access board, where the ADO gurus hang out.

Posting Permissions

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