I will ask a very simple question.I created a database with access and defined some fields and also an identity field.I took this file with ADODB connection and i want to write a code to add new records to this database file. I looked at some books and also MSDN for help but i could not understand how to connect the database to my program with this primary key(identity key)?Also it is defined as an automatic number but should i increase it manually while adding new records?