Access: Get list of all columns in DB that have "unicode compression"

Question

In Microsoft Access , is it possible somehow to get a list (via a SQL query ) of all columns that have UNICODE compression enabled ? Maybe by executing a query on some Microsoft Access system table ? Any ideas ?

Answer 1

Unfortunately no there is no way via a SQL call unless you use something like OleDbConnection.GetOleDbSchemaTable.

You can determine if Unicode compression is set by seeing if the field object contains a Property called UnicodeCompression. So, something along the lines of:

Public Sub HasUnicodeCompression( field As DAO.Field )
    Dim oProperty As DAO.Property

    For Each oProperty In field.Properties
        If oProperty.Name = "UnicodeCompression" Then 
            HasUnicodeCompression = True
            Goto CleanUp
        End If
    Next oProperty

    HasUnicodeCompression = False

CleanUp:    
    Set oProperty = Nothing

End Sub