access field types... and they fields ???????

[PP]

somebody could send me the list of "Field Types" supported for access

I am sending this command...

CREATE TABLE usuarios (
ID int(10) NOT NULL auto_increment,
IDUsr int(11) NOT NULL default "0",
Nome varchar(40) default "0",
SenhaExpira tinyint(3) NOT NULL default "0",
Validade datetime default NULL,
Nivel tinyint(3) NOT NULL default "0",
PRIMARY KEY (ID),
UNIQUE KEY idxLogin (ID,Login),
KEY idxNome (ID,Nome))

but they gives errors...
cold somebody help me..

Thanx in advance...

PP

 

[Allen Browne]

Use the DDL column of the table.

Some attributes can only be set with the DAO library, though.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

could you translate this sql code of mySQL to access to me...
I realy try to convert but I steel have many problens like AutoNumber and
size of Field...

thanx by the field types... but this autonumber is kiling me...

PP

 

[PP]

could you convert this sql to access, to me, I dont know how can I...
i´ll be gratefull..

PP

 

[PP]

please.. can someone convert this sql to access... because, I realy try but
this autonumber is killing me...

thanx....

PP