SSMA linking Tables

[Aliens]

I used SSMA to upsize Access2003 to SQL2005. The wizard automatically
created Linked tables to the database. Now I created new tables in SQL that
I want to link using the same connection as the current linked tables. How
do I find where or how that ODBC connection is setup?

 

[Lutz Uhlmann]

CurrentDB.TableDefs("TABLE").Connect

 

[golfinray]

If you are on a windows machine, windows has an odbc wizard in the control
panel. Then you do File\New\ and scroll all the way to the bottom and there
is your ODBC connection. Enter your server info and it should hook up.

 

[Aliens]

I assume you are talking about the Data Sources (ODBC) wizard under admin
tools of control panel. I have checked there, but I could not locate the
current connection file there under any of the tabs.

 

[Tony Toews [MVP]]

If you are on a windows machine, windows has an odbc wizard in the control
panel. Then you do File\New\ and scroll all the way to the bottom and there
is your ODBC connection. Enter your server info and it should hook up.

You can do that but we recommend not using the DSNs.I much prefer
DSN-Less connections as it is one less thing for someone to have to
configure and one less thing for the users to screw up. This is also
better for Citrix/TS farms where each individual system would have to
have a DSN created and maintained.

Using DSN-Less Connections
http://www.accessmvp.com/djsteele/DSNLessLinks.html
ODBC DSN-Less Connection Tutorial Part I
http://www.amazecreations.com/datafast/GetFile.aspx?file=ODBCTutor01.htm&Article=true
HOWTO: Use "DSN-Less" ODBC Connections with RDO and DAO
http://support.microsoft.com/?id=147875
ODBC DSN Less
http://www.carlprothman.net/Default.aspx?tabid=81
Relink ODBC tables from code
http://www.mvps.org/access/tables/tbl0010.htm

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/