Getting the table structure in ms access with SQL query?

Question

How to get the table structure in MS Access with a SQL query?

Using the following query:

SELECT name FROM MSysObjects

Results in the following exception:

Exception: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysObjects'.

Answer 1

Set up an ODBC connection for your postrgres database and then call the transfer database command for each of your tables.

Answer 2

To resolve the permissions issue for MSysObjects, see these similar questions: no read permission on 'MSysObjects', or Run C# queries against (hidden) system tables in Access?