how to find the number of fields and their names in ms access using vb6?
i am using dao database.

Okay, start a new standard exe project.
Add reference to DAO 2.5/3.51
Declare a tabledef variable

Dim T As DAO.TableDef

Highlight TableDef and press F1
Click Example and choose the second one down.


Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.