I am trying to understand the Link Database process in Access.
I have an Access 2007 database with Linked Tables to SQL Server 2008.
The issue I have is when I perform the link from my development machine via ODBC other users cannot open the linked tables from from their machine. When I perform the link in ACCESS from someone else machine, others are able to open the tables just fine.
So, I am doing something wrong on my machine OR have some version of ODBC installed that won't translate correctly.
The only difference I can see is the following: When looking at the 'tool tip' on the Access linked table there are the connection properties...
ODBC; DRIVER=SQL SERVER; SERVER=MYSERVER; UID=BOB;APP=Microsoft Data Access Components;..........
In the ODBC Create New Data Source, Workstation is using SQL Client 2000.85.1117.00 (FILE: SQLSRV32.dll)
ODBC; DRIVER=SQL SERVER; SERVER=MYSERVER; UID=BOB;APP=Microsoft Windows Operating System;.........
ODBC; DRIVER=SQL SERVER; SERVER=MYSERVER; UID=BOB;APP=2007 Microsoft Office System;.........
In the ODBC Create New Data Source, Workstation is using SQL Server Native Client 2009.100.1600.01 (FILE: SQLNCLI10.dll)
I am not sure how to affect/change the APP section during the ODBC Link Process in Access.
OR do I need to install the SQL Native Client on every workstation? If so, how do I do that?
Can anyone provide some insight?