This is pretty slick.
Found another handy blog on MSDN...Here's a way to create a DSN-less connection in Microsoft Access, very nice! Where I am consulting they use Access dbs to store static lookup information for their data marts/warehouses. And since it's a global organization with servers, databases, AS/400s, etc. all over the place, creating these ODBC connections to them gets to be a major pain. Check this out and see if you can use it!
http://blogs.msdn.com/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspx
Lee
---------------------
Happiness is a non-cluttered System DSN list!
3bec5b7d-487c-41c3-901c-a0fc537062b5|0|.0