Thanks for this Fofa and Flabrecque,
Can you please give me a link where I can find an example(.zip file or code) for this please. I am still working on it.
Please suggest me : if i keep all reports,forms,modules,queries in one .mdb file and all tables in another .mdb file, how to link them...