I have an Access database with linked tables to SQL Server 2005. I created it on my main XP Pro PC with Access 2003. This Access program will be shared with at least 20 more users on a network. I created an ODBC connection to link the database. I have tried to run the application on another PC with MY Windows login. The first time I would need to set up an ODBC and update the tables with the Link Manager in Access. Then I run a form with the code I found on this page http://www.accessmvp.com/djsteele/DSNLessLinks.html
It works fine. I close and reopen Access and the linked tables work fine, even on my main computer; works without having to update the linked tables.
When I go to another user I have a hard time trying to set up the ODBC, and when I finally do the linked tables fail and I get an ODBC Call Failed message on different tables. When I close and reopen access none of the linked tables work and I have to re-link them to the ODBC.
I am wondering if this could be a permissions issue, if so which one? I am a local administrator on my main PC. I would really appreciate any help on this matter. Thanks.