Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VB6 & Access 97 Verify & Alter Table
Message
From
14/11/2002 17:58:37
 
 
To
14/11/2002 16:47:39
Bobby Yates
Technology Solutions Consultants
Frisco, Texas, United States
General information
Forum:
Visual Basic
Category:
Access
Miscellaneous
Thread ID:
00722960
Message ID:
00722985
Views:
15
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?...

Previous
Reply
Map
View

Click here to load this message in the networking platform