Results 1 to 3 of 3

Thread: Need a hand...

  1. #1

    Thread Starter
    Member
    Join Date
    Nov 1999
    Location
    alb, nm 87112
    Posts
    56

    Post

    How would I access more than one table in a database at once using VB's Data Control?

    I know I have the option of "looping" through all tables, but this is a simple delete query, and I'd rather not waste time looping if I don't have to.

    Thanks!

  2. #2
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    You can't perform delete on more then one table. It means that if you want to delete something from every table you have to either loop through table collection or call the Delete statement manually for each table.

    ------------------

    Serge

    Software Developer
    Serge_Dymkov@vertexinc.com
    Access8484@aol.com
    ICQ#: 51055819



    [This message has been edited by Serge (edited 12-14-1999).]

  3. #3

    Thread Starter
    Member
    Join Date
    Nov 1999
    Location
    alb, nm 87112
    Posts
    56

    Post

    Hi Serge,

    That's what I thought. I was just hoping there was a way to do it without the annoying loop, and changing the datasource for each.

    Thanks for your help.


Posting Permissions

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



Click Here to Expand Forum to Full Width