May 25, 2022, 05:39:08 PM

News:

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.

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
When all else fails, get a bigger hammer.