http://blogs.msdn.com/b/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspxSometimes you may want to use Access as a front end for SQL Server. When doing this you typically have linked tables to the SQL Server and you have the .mdb on a shared drive for users to access. Normally you create a DSN and use that for theen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspx#10387196Tue, 22 Jan 2013 14:55:27 GMT91d46819-8472-40ad-a661-2c78acb4018c:10387196Kris<p>I haven&#39;t used Access since 2003, but why wouldn&#39;t a File datasource on a drive w/ UNC mapping work?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10387196" width="1" height="1">http://blogs.msdn.com/b/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspx#10236961Mon, 14 Nov 2011 19:26:42 GMT91d46819-8472-40ad-a661-2c78acb4018c:10236961robert<p>Than you Thank you thank you. I&#39;ve been searching for 2 days to find an example I can follow. all the others I found were so complex. this is perfect</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10236961" width="1" height="1">http://blogs.msdn.com/b/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspx#9932223Thu, 03 Dec 2009 21:54:42 GMT91d46819-8472-40ad-a661-2c78acb4018c:9932223SebAnt<p>Thank you very much, Maspeng!</p> <p>I spent a lot of time googling for this. Found several links for older versions, all of which gave some errors with Access 2007 &amp; SQL2005.</p> <p>Your solution worked like a charm!</p> <p>Sebastian</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9932223" width="1" height="1">http://blogs.msdn.com/b/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspx#9927952Tue, 24 Nov 2009 14:13:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:9927952Lee Everest<p>Very handy. Thanks for posting.</p> <p>Lee Everest</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9927952" width="1" height="1">http://blogs.msdn.com/b/spike/archive/2009/11/24/how-to-create-a-dns-less-linked-server-in-access-to-sql-server.aspx#9927857Tue, 24 Nov 2009 11:01:57 GMT91d46819-8472-40ad-a661-2c78acb4018c:9927857ralphthomson01<p>Hello</p> <p>I really have to say thank you on this one, i have been trying to figure it out this for some time now and this post has been very handy for me. You really have saved lots of time !</p> <p>Thanks a lot !</p> <p>Ralph</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=9927857" width="1" height="1">