How do You set up a DSN Less Connection

[bconner]

I have a Access Database with 2 linked tables that are linked to SQL Server. At some point I want to be able to distribute this database to a couple other locations without having to create an odbc on the users end. How can I setup up a DSN Less connection that will connect the 2 tables to SQL Server?


Any help is appreciated...
Brian

 

[HiTechCoach]

Brian,

I use this by a fellow Access MVP:

Using DSN-Less Connections