Hie. Erm. Guess I'm the first person to post a thread to this Forum. Well, anyway, is there a method where such that 2 database can be joined together into 1 major database? And how about tables inside these databases? What if I want to join these tables from each respective databases into one single database? I welcome your opinions, thoughts, ideas.... :D

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

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

Another thing people. I wanted to ask the acceptable names for Access Database? What if a database happens to have a $ at the front of the name? Eg. $2001tocurrent.mdb??

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

I don't know if you can name an Access database with a non-standard character. If there is not a specific reason why you have to use a $ character then avoid it.

From a design perspective there is no methodology allowing joining of two table designs. The only way is to redesign both into one. There are architectural methods of course.