Hmm. That is a very good question rsTelma. I actually misinterpreted what was actually said by my Officer. :( I'm in deep trouble because I've spent almost 6 weeks in my attachment period just thinking how to consolidate tables from multi-databases when the actualy interpretation was just to manually cntrl-c & cntrl-v the records from these tables to the designated table. I've wasted a whole good time. But now, the real task is to copy the multi-rows of records from multi-tables of multi-databases into 1 table. Now, the real situation is here rsTelma. The records from all these tables contains multiple rows with multiple columns. And some of them has below than 1000 records while some of them has over than 60,000 records.

My Officer wants me to compile all these records into 1 table. I am just wondering, because I'm very new to this Access DB, what would happen if I wanted to display all these records in an ASP page? Wouldn't there be some functionality problem?

I'm in a panicky state where I've not yet develop any real ASP pages to show to my Officer. What should I do rsTelma?

* Love me for a reason; Let the reason be love *