Hie everybody. I'm new here. I have a problem. I'm currently under attachment. And my project requires me to do high levelling of ASP & Access Database. I have a question. Currently, I have multiple databases but I will summarise this. Let's say I have 2 database which are called Jan.mdb & Feb.mdb respectively. In these 2 database, I have tablename called MyTable. The values for these tables are exactly the same. So, can I join these 2 tables up to make them into 1 master database?If it is possible, can you please tell what should I do next? And how to reach my goal? I have never, I repeat never done this at school or in any of my experience in programming of ASP. I really need your help in this. Please. Thank you.

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

This is fairly easy to do. Create a copy of one of the databases and rename it so you know it is the master database. For example, change Jan.mdb to Master.mdb.

Then open Master.mdb, select Insert > Table > Import Table.

Find the second database, open it, find the matching table and select it, and then import all but the primary key field (I am assuming it is an autonumber field so it won't go - unless the PK field is not an autonumber, then you can bring it in) and import it into the existing table that it matches.

You can continue to do this for all subsequent copies of the database, pulling into the matching table.

You can do this offline. Just pull the databases out of your site, import all the data, and then paste the master back to your site and make the proper associations to it.

I am not sure how you would do this is ASP, but it is basically an append query.

HTH


mmcdonal