If you use DAO to access MSAccess database, use:
Database.TableDefs([Index])
TableDefs is collection, containing all table structures. TableDefs([Index]) returns TableDef object, which contains Fields() and Indexes() collections, which you can use to obtain information about this objects.
Also see "TableDef Object" topic in MSDN.
Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...
