OleDbConnection.GetSchema MS Access list of Tables, Columns, Key columns

I have submitted a couple of community content pieces of code here.

They give details on how to use the ole getschema method to retrieves the schema from an access database to get tables, columns, or key columns.

Microsoft Access version of Coalesce

Ever need to use Access for something only to learn that the handy coalesce function doesn't exist?

Turns out Access has a function by a different name that performs a similar though slightly more limited function.

Syntax: Nz(value, valueifnull)

Read about it here.