i tried deleting the default table when opening access at the first time, and then i run my queries it worked, but what i can't understand is that the same format of queries i used to create another table, it failed! so i still can't put the finger on what access wants when creating a table.