Retrieval of schema information in access database

Question

I am writing an application which connects to an access database using an OleDb connection. Is it possible to connect to an access database which I have not created myself and retrieve information about the schema of the database, all i need are the name of all the tables in the database? I was looking for a SQL statement such as SELECT * FROM SchemaTable Does Access have a standard internal table describing the database? If none of this is possible is there a database that does e.g. SQL Server dbs? I have looked at many examples of ADO.Net applications to find this done, but all of the examples I have looked at seem to require a pre-existing knowledge of the names of the tables that are being queried, before any data access can start.