When working with SQL Server it is easy to get access to database metadata like tables, stored procedures etc, by using the sys* tables. I was doing some work with Access and wanted to do something similar, turns out that it is quite easy to do.
Basically the
OleDbCommand.GetOleDbSchemaTable() method allows you to get as much metadata you want about the DB.
Pretty obscure but a God send when you really need it :)