Access field types and lengths

[billhsln]

We have a way to get the field names from an access table, but I need to know the field type and length.  In other databases there are tables you can use.  Supposedly we could do a select from MsysObjects, but when I try this, Access says I don't have access, even though I am running as Admin.

Thanks,
Bill