[Resolved] ADOX and Auto-Increment Fields...

[nlhowell]

I am attempting to create Access databases dynamically with ADOX; for example:

$adoxCatalog = new COM("adox.catalog");
$adoxCatalog->Create("Provider='Microsoft.Jet.OLEDB.4.0'; Data Source='database.mdb'");

creates blank database 'database.mdb'.

However, this creates a problem:

$adoxCatalog = new COM("adox.catalog"); // create catalog
$adoxCatalog->Create("Provider='Microsoft.Jet.OLEDB.4.0'; Data Source='database.mdb'"); // create database
$adoxCatalog->Tables->Append("MyTable"); // create table
$adoxTable = $adoxCatalog->Tables->Item("MyTable"); // assign table to $adoxTable
$adoxTable->Columns->Append("ID"); // create column ID
$adoxTable->Columns->Item("ID")->Properties->Item("AutoIncrement")->Value = true; // fails, although the VB/ASP equivelant works fine

Any idea on how to make a field auto-increment?

Thanks,
Nick

[nlhowell]

Anyone?

[nlhowell]

In case anyone was wondering, I found a solution. Instead of using ADOX (which I continue to use for reading a data definition), I used an SQL query:

CREATE TABLE [table] ([ID] autoincrement, [field1] memo);