Modify MS Access table with VB and ADO

[Michael Kolechkin]

Hello BaBa

> Does anyone konw how to modify an existing MS Access Table
> with VB and ADO (ie, to add or delete fields to a existing
> table etc.)
You can use either DDL (Data Definition Language)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/od
bcddl_statements.asp
with ADO or use ADOX (ADO Ext.)
Atricles about ADOX:
on MSDN
http://support.microsoft.com/support/kb/articles/q303/8/14.asp

on codeguru (with some samples):
http://www.codeguru.com/mfc_database/ADOX_in_details.html

> thanks.
You are welcome.

[Val Mazur]

hi,

Use ADOX library to do that

Val

>-----Original Message-----
>Does anyone konw how to modify an existing MS Access
Table
>with VB and ADO (ie, to add or delete fields to a
existing
>table etc.)
>

>thanks.
>.
>