Create DSN-less connection in Microsoft Access to SQL Server

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!