getting field count on an Access table 
Author Message
 getting field count on an Access table
Hello,

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.



Sat, 24 Jul 2004 08:52:23 GMT
 getting field count on an Access table

John

TextBox.Text=ObjRecordset.Fields.Count

Sukesh



Sat, 24 Jul 2004 21:35:34 GMT
 
 [ 2 post ] 

 Relevant Pages 

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


 
Powered by phpBB® Forum Software