Reading Access97 files in VB4
Quote:
>I need to write a program that will look at an Access Table, and return
>the names of the fields in that table. Any suggestions?
Iterate throught the fields collection of a tabledef object. This is
just straight DAO stuff:
dim db as database
dim td as tabledef
dim fld as field
set db = dbengine(0).opendatabase("yourdb.mdb")
set td = db.tabledefs!sometable
for each fld in td.fields
msgbox "Field: " & td.name
next fld
-- Jim Ferguson, FMS
http://www.*-*-*.com/
