Link SQL Server Table to Access

[db2nd]

Is there any way to create a link in Access to a SQL table without having the
user manually create the DSN using the admin tools? My hope was they could
access the sql table (view only) without manually creating the DSN.

Thanks for your help.

 

[Amy Blankenship]

Is there any way to create a link in Access to a SQL table without having
the
user manually create the DSN using the admin tools? My hope was they
could
access the sql table (view only) without manually creating the DSN.

http://www.accessmvp.com/djsteele/DSNLessLinks.html

 

[Douglas J. Steele]

http://www.accessmvp.com/djsteele/DSNLessLinks.html

Just to be clear, that sample assumes that the tables were originally linked
using a DSN, and it replaces the links with DSN-less connections.

That having been said, since that code deletes the existing table and
creates a new one, it's really not a requirement. It was just an easy way
for me to determine which tables needed to be linked!