Retrieve all the table names (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

accessman -> Retrieve all the table names (6/28/2006 18:53:12)

Hi:

In the database, I want to create a combox in the form, it the dropdown list show all the table names I created, or linked.

I don't want to create a table to store the table names.

Can we retrieve the table names from the Tables sections directly?

Thanks.



rdouglass -> RE: Retrieve all the table names (6/28/2006 20:48:04)

This help any?

http://www.kamath.com/codelibrary/cl002_listtables.asp



accessman -> RE: Retrieve all the table names (6/29/2006 0:16:50)

Not ASP.

I want to work with MS Access forms, Visual Basic in the MS Access Forms.

Can we use ADO to make it ?

Thanks.



rdouglass -> RE: Retrieve all the table names (6/29/2006 9:13:43)

Well, I'm not sure how to do it within Access it self but this SQL *should* return the list of all tables and views regardless of how you send it to Access:

SELECT MSysObjects.* FROM MSysObjects

That help any?



accessman -> RE: Retrieve all the table names (6/30/2006 12:13:15)

Thank you.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875