Environment: SQL Server 2008 Enterprise; Windows Server 2008
Client: Access 2007; User is db_owner of database
I have a user that is set to be db_owner of a database. When he tries to create a linked table in MS Access 2007 get gets a timeout error. Of course when I set him to sysadmin it will allow him to link to the tables. If I remove him as sysadmin he can still use the linked table without any issue.
@jcumberland had me ensure the the database is selected in the DSN it did not help.
UPDATE: We are using Windows Authentication in this scenario.
Microsoft SQL Server ODBC Driver Version 03.85.1132
Data Source Name: DataSourceName
Data Source Description: DataSourceDescription
Server: ServerName
Database: DbName
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
Update #2: I have opened a ticked with Microsoft regarding this issue and will update this issue with more information as we have it.
