What is the way to add a new table to an Acces DataBase using ADO ?

and

What is the way to define the fields, indexes to the new table?

Thanks

--
Alejandro Castro
www.alfra.info
alejan...@alfra.info

3eeb620...@newsgroups.borland.com

[...]

You can use either ADOX or SQL DDL.

--

 A: Top-posters.
 Q: What is the most annoying thing on Usenet?

Hi Alejandro,

 It is very easy to create a table in Access using an ADOQuery component.
The syntax is simple and here is an example:

  Create table table_name (fieldname1 fielddefinition1, ...fieldnameN
fielddefinitionN).

  create table CUSTOMER (customerid integer, [last name] varchar(30), [first
name] varchar(30))

An index can be created like this:

  create unique index CUSTOMERIDX on customer(customerid)

The syntax is not case-sensitive and of course use the 'UNIQUE' qualifier
only where appropriate.
Note that tablenames or fieldnames that have embedded spaces must be
enclosed by [] as tihs is a requirement of Access.

Regards,

Michael

news:3eeb7a37@newsgroups.borland.com...

I think, ADOX could be the prefered way, because MS Access sets a
stupid flag for string fields by default, when using DDL.
I talk about the flag "allow empty strings".

cu Christian