SQL Server -> MS Access ODBC Question 1

[arniec]

I have a SQL server set up and want to create an Access Database which will reside on a network share and hit the SQL Server. It is pointing to the SQL server through an ODBC connection. This database will be used by dozens of people; is there any way to get it set up where I do not have to manually install the ODBC connection on each of their XP machines? Can it be set up in the Access file itself and then anyone who hits the Access file would be able to reach the SQL Server?

Thanks!

 

[cmmrfrds]

You are referring to what is commonly called a DSN-Less connection. See this site for examples.

http://www.carlprothman.net/Technology/ConnectionStrings/ODBCDSNLess/tabid/90/Default.aspx

See this thread705-1214980 for an example of one method.

 

[arniec]

That code is very interesting. I have some other cases where it will come in quite handy, but it appears to be using code to do this. Can these connections be used to create linked tables in Access?

Thank you!!!!!!!!!! I appreciate you taking the time to help me.

 

[cmmrfrds]

The code is creating linked tables in the MDB file where the code is run. After the link is established it is saved with the MDB app. When you copy the MDB to another PC the link is already established in the MDB.

 

[arniec]

Works wonderfully, THANK YOU!