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