Is it just me or is Access wierd when connected to C#? For e.g. the following query works:

Insert into table values('1', '2');

However this does not:

Insert into table (username, password) values ('1', '2');


If I take the 2 queries and paste it into the query facility in the access database both of them works fine! But for some reason the first one is working and the second one is not (and the second one is correct).

I never met this problem with oracle or sql server, is this normal?