Board index » delphi » How can i create a new table in a mdb with ADO

Baldemaier Florian

Delphi Developer
Sun, 29 Sep 2002 03:00:00 GMT

How can i create a new table in a mdb with ADO

I use the component "TaoADODataSet" which i connected to a mdb via ADO.
my problem is:

how can i create a new table ?
how can i delete a table ?
how can i make a new mdb file ?

please help me.

Maybe someone know about a really good component do access a mdb like
"TaoADODataSet" (freeware).

thanks
Baldemaier Florian

 
Brian Bushay Tea

Delphi Developer
Mon, 30 Sep 2002 03:00:00 GMT

Re:How can i create a new table in a mdb with ADO


Quote
>I use the component "TaoADODataSet" which i connected to a mdb via ADO.
>my problem is:

>how can i create a new table ?

use SQL Create Table
Quote
>how can i delete a table ?

use SQL Drop Tabe

Quote
>how can i make a new mdb file ?

You will have to import ADOX Type library and then use code like this

uses ADOX;
var
   ADOXCataolog:TCatalog;
begin
ADOXCatalog.Create1('Provider=Microsoft.Jet.OLEDB.4.0;Data Source=new.mdb');
end;
--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. Want to create a new table using ADO ...

2. Create a new Access .MDB from Delphi??

3. Creating an .mdb database via Delphi 5 and ADO

4. Add a new Table to a MDB Database

5. Copy a table from a .MDB to other .MDB

6. Create of Tables SQLServer -> Access.mdb

7. ODBC -- problem creating .mdb table

8. Create a new MDB or a Table with ADO ?

9. Record locking with ADO Express, ADO 2.5 and Access 2000 .mdb files

10. creating new tables from old tables