Number of fields within a table

[John Palm]

Hi there,

Is there a way (function) to check the number of fields in a table by a query?

Thanks for any reply,

 

[Allen Browne]

Try:
dbEngine(0)(0).TableDefs("MyTable").Fields.Count