Access 95 / VB6 Autonumber

[sanjaypatel6685]

All,

I need to create a new table via VB6 DAO.


create table users
(user_id counter CONSTRAINT PrimaryKey primary key not null
,UserName Text(200)
,lastname text(200)
)

works fine with Access 2000 however VB6 DBO works with Access95 and I get a syntax error.

Can anyone help me convert the above statment so that it will work with Access95?

I am keen in creating this table with the Autonumber.

Thanks

Sanjay