Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VB6 & Access 97 Verify & Alter Table
Message
De
14/11/2002 17:58:37
 
 
À
14/11/2002 16:47:39
Bobby Yates
Technology Solutions Consultants
Frisco, Texas, États-Unis
Information générale
Forum:
Visual Basic
Catégorie:
Access
Divers
Thread ID:
00722960
Message ID:
00722985
Vues:
16
Follow object hierarchy of the database:
DBEngine - Workspace(s) - Database(s) - TableDef(s) - Field(s)
When open database, TableDefs collection contains all tables, defined in this database (including system tables, which names begin with MSys, if I remember correctly; you should skip them!). You can iterate through this collection and using Append and Delete methods you can create/delete tables into database.

Each TableDef object contains Fields collection, which contains all defined fields into table. You can iterate through this collection and using Append and Delete methods you can create/delete fields into table.

Refer MSDN for further information about working with these collections and/or methods.

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?...

Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform