Hi all,
i am currently working on software which has divided up its tables over 5 databases. all the tables inter-relate with each other between the databases through code (ie. two databases opened and a table opened from each and a relation is established through code).
going on this setup, i can't for the life of me figure out why in the world they split up the tables into 5 databases. is there any benefit in doing this??

i ask because i am changing over to using ADO controls and i don't want to have to create more connections than needed.

Jordan :)