Wrox Programmer Forums
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 17th, 2003, 09:54 AM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Opening unknown table names

I'm trying to access all tables in a database where I don't know the table names before hand. I've tried "SELECT * FROM * " but get a FROM clause error. Does anyone know how I can do this?
 
Old July 17th, 2003, 09:58 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

hi there..

that can be accomplish depending the type of connection you are using..

dao has a tables collection
ado has a adox catalog that you can open and see all the tables...

HTH...

Gonzalo Bianchi
 
Old July 17th, 2003, 02:37 PM
Registered User
 
Join Date: Jun 2003
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

PERFECT!!!!! I am using ADO and having it working fine. Thanks a lot!





Similar Threads
Thread Thread Starter Forum Replies Last Post
"Unknown error" message when trying to open table el_oliver SQL Server 2000 2 January 4th, 2007 04:41 AM
Unknown table 'char_main' in MULTI DELETE uniacid Beginning PHP 9 December 11th, 2006 04:59 PM
Unknown Error "-1" when opening new website MzMoody BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 2 November 10th, 2006 01:08 PM
opening direct file names client side grhind ASP.NET 1.0 and 1.1 Basics 3 August 14th, 2006 03:22 PM
Find Unknown Worksheet Names in an Excel Workbook bcarmen VB.NET 2002/2003 Basics 1 March 3rd, 2005 12:20 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.