How to create tabledef within ADO?

[Dave Drennan]

Bryan, you should start off with this document. It's a good start for
migrating from DAO to ADO. Hope it helps.
http://www.microsoft.com/data/ado/adotechinfo/dao2ado.htm

"Bryan Parkoff" <BPar...@satx.rr.com> wrote in message
news:VsGt4.1989$w81.2...@typhoon.austin.rr.com...
> How to create tabledef within ADO?
>
> I use DAO 3.51 that has tabledef statement. I use MS Office 2000
> Premium that has MS Access 2000. MS Access 2000 does not support DAO 3.51
> anymore, but it does support ADO.
> A problem is that ADO does not have tabledef statement so I can't
create
> tabledef. I have ADO 2.1 within MS Visual Studio 6.0 including Service
Pack
> 3.
>
> Please advise...
>
> Bryan Parkoff
> BPar...@satx.rr.com
>
>
>

[Bryan Parkoff]

[Marcos Masagão Ribeiro]

You can try using ADOX (Microsoft ActiveX Data Objects Extensions )
By addind a reference to Microsoft ADO Ext. 2.5 for DDL and security on your
project

Bellow some procedures avaliable
Method Description
Append (Columns) Adds a new Column object to the Columns collection.
Append (Groups) Adds a new Group object to the Groups collection.
Append (Indexes) Adds a new Index object to the Indexes collection.
Append (Keys) Adds a new Key object to the Keys collection.
Append (Procedures) Adds a new Procedure object to the Procedures
collection.
Append (Tables) Adds a new Table object to the Tables collection.
Append (Users) Adds a new User object to the Users collection.
Append (Views) Adds a new View object to the Views collection.

Bryan Parkoff <BPar...@satx.rr.com> escreveu nas notícias de
mensagem:VsGt4.1989$w81.2...@typhoon.austin.rr.com...