Good introduction.  I expect more in-depth articles on this subject to follow.

I have used this to attach, remote SQL servers, Access databases, and even text files.  I have even heard of attaching DB-400 through Client Access.

Somebody asked about multiples.  Yes you can.