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!
Printable View
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!
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).]
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.