I dont want to use MDB format pbaldy because I am also after Access 2007 db password security. there may have been problem with the link you provided pbaldy because its not accessible "page load error". Maybe you can give me the gist of the link you provided, please.
Galaxiom, what do you mean I need to outer join the two tables from two databases?
Oh I see. You mean so that I will not have this error due to duplicate records, I should make a criteria where the primary key is null.
Wait, Can you kindly edit my code above and include how the outerjoin and isnull criteria will appear. Im kinda still weak in that area. Kindly please.
Moreover, if I will use outerjoin, I need to link the table1 from database2 to table1 of database1. Should I need to link first or not needed?