Sorry if this has been asked before but I couldnt found any good reference on this (:

Lets say we have 2 ms access db. I want to append the second to the first soo all the records of the second db will be at the end of the first and that their indentification number(of the appended records in the first db) will start by the number of the last indentification number of the last record in the first database (sounds funny) How do I do that? I tried numerus things but my attempts were unsuccessful.

DAO is very simple but this is beyond me for now. I would apprichiate any replies.