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

Hi Damien,

This error is sometimes indicative of issues with MDAC on the machine.
Were these machines imaged? Have you applied all updates to the machines?

Please download Comchecker from the following site:

http://support.microsoft.com/default...b;en-us;307255

Run this utility on a problem machine, and if it is less than MDAC 2.7,
please update your version of MDAC on the machine at the following site:

http://msdn.microsoft.com/library/de....asp?contentid
=28001860

Test the issue and see if this resolves. : )

Best Regards,

Rebecca Casselman MCDBA, MCSA, MCSE NT4/2000
Microsoft Online Support Engineer

Get Secure! - www.microsoft.com/security

================================================== ===

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.