Connecting to SQL server 7.0 from Access XP

[Damien Sanderson]

In our Access 97 application, running on W2000 machines, we linked to
tables held on our MS SQL server 7.0. The SQL server is set for
trusted connections. So with a connection string property on the link
some thing like ...

ODBC;DRIVER=SQL SERVER;SERVER=server_name;
DATABASE=database_name;TABLE=dbo.tablename

.... you could access the tables transparently with no problems having
to logon to the SQL server.

We upgraded our client machines to Office XP professional and XP OS,
but now you can only transparently access the tables if you are an
Admin. If you are an ordinary user there is a log delay followed by
the message

Connection failed:
SQLState: 'S1T00'
SQL Server Error 0
..... Timeout expired

It then offers a SQL server login dialogue box all set up for a
trusted login - you click OK and you get access to the tables.

Cannot even create a new link connection / DNS file as a non Admin.

I have tried many different forms of connection string for the links
.... but the results only work for Admins and not ordinary users.

Any help greatfully received

Damien