Board index » Database Programming
All times are UTC
I want to read the number of fields in an Access database table. Can anyone tell me the best way to do this through ADO? I don't want to use ADOX as it isn't on out production machine.
thanks for any help, JJ.
TextBox.Text=ObjRecordset.Fields.Count
Sukesh
1. Getting SQL table row count in Access ?
2. Getting a list of Tables and fields in an access database
3. Getting A count of unique fields in a GROUP BY
4. error by getting count of rows from a table
5. Getting Record Count of a table quickly
6. Getting a count(*) from multiple archived tables
7. Getting count(*) for all the tables in the database
8. Getting record count of detail table
9. Fast table count or table block count needed.
10. Getting data from Access tables with VB6 without Access
11. Syntax error COUNT() : Using COUNT() with char field
12. SP to count # times a value is found in a field for a table
getting field count on an Access table