create a new table (ADO)

From: Mike Shkolnik (mshkolnik2002_at_ukr.net)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 14:21:36 +0200

Is any way to create a new table in database?

I know about CREATE TABLE and ADOX.Catalog but I want to know how to create
a new table in another way. All what I want is to create some resultset
(Fields.Append) and specify the table name+save/commit - or this is
impossible in ADO?

PS: I don't want to use the CREATE TABLE because syntax for field types is
not same for all databases. And I don't want to use the ADOX because I'm not
sure that new version of ADO will be installed for all my end-users... 

--
With best regards, Mike Shkolnik
EMail: mshkolnik@scalabium.com
http://www.scalabium.com

Relevant Pages

  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Requery of Listbox does not display new data
    ... add a record to the database. ... Then the Lisbox control's requery method is ... The ADO command is run using a connection string to the mdb containing the ... Dim cmd As ADODB.Command ...
    (microsoft.public.access.formscoding)