insert into syntax problem

[excession]

in mysql, to insert a record into a table with an autoincrement primary key you use
insert into myTable values ('null', 'blah', 'blah')

when i try this with access it throws an error

what is the syntax for access so that it autonumbers the primary key field?

see... I'm no good with access



Looking for a job as a programmer in Bristol UK.

 

[PHV]

INSERT INTO myTable (Fields list WITHOUT the autonumber) VALUES (...)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[excession]

Thank you, that i can do, but it does mean rewriting every method that inserts data, is there an equivelent to the mySQL where i don't need to list very field?

Looking for a job as a programmer in Bristol UK.