Read all tables of database

[SIMIN]

Hi forum members! :)

I have a question in my mind:

I want to read from an Access .mdb database file.

This code works if I want to read the contents of a specific table from database:

Dim StringConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileTextBox.Text + ";Jet OLEDB:Database Password = " + PasswordTextBox.Text
Dim MyConnection As New OleDbConnection(StringConnection)
MyConnection.Open()
Dim MyCommands As New OleDbCommand("SELECT * FROM MyTable", MyConnection)
MyConnection.Close()

However, I want to do a different thing!

I don't know if my database has any tables or not? Perhaps it has, so I just want to get the name of all tables in database.

How can I get the name of all tables in database using the above code?

Thank you friends :)

[Machaira]

Google is your friend - http://www.mvps.org/access/queries/qry0002.htm

 

:)