How to get all Access database tables except hidden ones?

Question

.NET

Can you tell me how can I get a list of all tables excluding hidden ones?

restrictions[3] = "Table";
                DataTable tables = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, restrictions);

Returns all tables to me, including hidden user tables, even though I don't need it.
How can I achieve the result I want?

Answer 1

Можно попробовать посылать такой запрос к БД Access:

SELECT MSysObjects.Name AS table_name, *
FROM MSysObjects
WHERE Left([Name],1)<>"~"
        AND Left([Name],4)<>"MSys"
        AND MSysObjects.Type In (1,4,6)
order by MSysObjects.Name