Retrieve MSAccess Table structure / column info

Hi DB Guru's :)

I have a problem, I'd like to know the column datatypes of some tables in an MS Access database. It's going to be a pain for me to get hold of the file and a copy of ms access to open it that way rather than a query. Does anyone know the query I can use to retrieve the information.

for example with an sqlite3 db i can do this "PRAGMA table_info(" + tablename + ");" and i'll get a resultset with like name, type and a few others, a row for each column of that table. I found examples for SQLServer but not MSAccess I assume it's still capable of it, just not commonly known.