Re: create a new table (ADO)

From: Andrew (abaylis_nos_at_spamcop.net)
Date: 01/26/05

  • Next message: Viatcheslav V. Vassiliev: "Re: create a new table (ADO)" 
    Date: Wed, 26 Jan 2005 17:37:07 +1100

    "Mike Shkolnik" <mshkolnik2002@ukr.net> wrote in message
    news:41f72ff5@newsgroups.borland.com...
    >> i) If you generate a table via field definitions and then hope to be able
    > to
    >> create it in the underlying database, aren't you doing exactly what ADOX
    > is
    >> there for?
    > As I remember, the ADOX is not installed with old ADO/MS Jet
    > Or do you want to say that any ADO setup includes the ADOX.Catalog?
    >
    >> iii) If you really want to move out of ADO, you could use the DAO objects
    > I don't want to move from ADO. I want to use the pure ADO, not
    > ADOX.Catalog
    > or any database DDL (like CREATE TABLE)
    > In DAO I can create a table using
    > CreateTableDef+CreateField+TableDefs.Append. I need the analogue for ADO
    > --
    Mike,
    According to Microsoft, all versions of the MDAC release have included ADOX.
    As ADO and ADOX are installed as part of the operating system from Windows
    ME upwards, it would seem sensible to use the Catalog object form ADOX to do
    what you want.
    As you have found, ADO does not have any routines for the creation /
    modification of underlying database objects - that's what ADOX is for.
    Cheers,
    Andrew

  • Next message: Viatcheslav V. Vassiliev: "Re: create a new table (ADO)"

    Relevant Pages

    • Re: refreshing linked tables: NO DAO
      ... Can't be done with ADO, but it is possible with ADOX. ... Dim objFECatalog As ADOX.Catalog ... Dim strTableNm As String ...
      (microsoft.public.access.modulesdaovba)
    • Re: class events stop firing with ADO 2.8
      ... ADO would be Microsoft ActiveX Data Objects 2.8 Library ... ADOX would be MS ADO Ext.2.8 for DLL and Security ... First you'd need to save the addin when the references ... Once that reference is replaced the> Add-in works for ADO 2.8. ...
      (microsoft.public.excel.programming)
    • Re: ADOX - Import type library into Delphi 2007
      ... I want to modify an Access database at runtime and this takes ADOX (not ... only ADO but also ADOX so you can f.ex. ... How do I do that in Delphi 2007? ... It's totally different and renaming ...
      (borland.public.delphi.database.ado)
    • Re: DAO und ADO parallel verwenden ?
      ... in einer Access-DB die Tabellen ... > sowohl mit ADO als auch mit DAO zu bearbeiten, ... eindringlich vor der Verwendung von ADOX in Verbindung mit MDE Dateien ...
      (microsoft.public.de.access)
    • Re: create a new table (ADO)
      ... > i) If you generate a table via field definitions and then hope to be able ... > create it in the underlying database, aren't you doing exactly what ADOX ... the ADOX is not installed with old ADO/MS Jet ... Or do you want to say that any ADO setup includes the ADOX.Catalog? ...
      (borland.public.delphi.database.ado)