May 28, 2023, 04:20:23 AM


IonicWind Snippit Manager 2.xx Released!  Install it on a memory stick and take it with you!  With or without IWBasic!

Access field types and lengths

Started by billhsln, October 06, 2020, 05:00:51 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.


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.

When all else fails, get a bigger hammer.