June 14, 2024, 03:36:13 AM


Own IWBasic 2.x ? -----> Get your free upgrade to 3.x now.........

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.