List out all tables in MS Access with ODBC provider

Question

User1503731427 posted

Hello friends i am using windows application with VB code i want to display list of all available table name in the given database and i want to use odbc provider pls any one help me..

Answer 1

User-1199946673 posted

am using windows application with VB code

 

In that case, ask your question somewhere else, because these forums are intended for ASP.NET (web) related questions only:

http://windowsclient.net/Forums/

Answer 2

User814867896 posted

If your app has enough rights, you can get a list of tables using SQL query:

SELECT Name FROM MSysObjects WHERE Type = 1

Answer 3

User-1199946673 posted

SELECT Name FROM MSysObjects WHERE Type = 1

 

 

That will return the systemtablenames also!

SELECT [Name] FROM MSysObjects WHERE [Type]=1 AND [Flags] = 0