in reply to Re^3: Access won´t allow ENUM, DEFAULT etc in CREATE
in thread Access won´t allow ENUM, DEFAULT etc in CREATE

I took far more steps befor I got at this point and knew that the problem was with ENUM ;)

I´ve solved this problem a bit ugly. I made in the query a variable wich will take the 'shape' of the database flavour.
"CREATE TABLE ".$row[0]."(id $db_ind PRIMARY KEY,..
So in MSAcces 97 it wil be:
$db_ind ="COUNTER"
And in MSAcces 2000+:
$db_ind ="COUNTER NOT NULL"
In MySQL:
$db_ind ="AUTO_INCREMENT NOT NULL"

Well, this is the basic thought. For now I have to find out how many databases support this and which one might this company purchase.