Im having trouble running reports from a MSAccess 2000 database via tables linked to a SQL 6.5 database. ODBC SQL driver version 2000.85.1022.00
When the reports are run by an administrator the ODBC connection runs via named pipes as expected. However for regular users the ODBC connection defaults to TCP/IP and the queries take an inordinate amount of time to run or fail to complete.
When a user attempts to reconfigure the ODBC connection to named pipes, they get the following message from SQL Client Network Utility.
Your login account does not have the permissions required to make this operation. Consult your system administrator to obtain the required permissions in your windows registry.
If the user is given administrative rights the ODBC connection configuration then defaults to named pipes.