wow 1.2 Million Seconds

Are all transactions properly committed before logging out? All locks are freed? All cursors are properly closed & deallocated?

Is this with each connection?

Adding the name & ip to the windows hosts file?

windows\system32\drivers\etc\hosts

do you have some sample records?

There could be a flaw in one of the indexes.

Have you tried dropping & rebuilding them?

A difference between SP3 & SP4 is that SP4 doesn't always convert the variable to the matching datatype of the table column and might choose to convert all rows to...

Hello,

If you have any questions about sql server, post them in the forums. The scope of your question is rather broad.

Error checking is quite limited in sql server 2000.Basically you...

Have you checked consistency of the database(s)?

Does it occur when a certain statement is started? (sql profiler is a help here)

indeed odd.

Found it works with binary collation for this selection.

select * from test order by [name]

COLLATE Latin1_General_BIN

Have you tried updating Access 2000 servicepack 1 to service pack 3 or later?

Mdac is up to date?

Thanks for the suggestions. I will try them out.

The tab security of your linked server to A is completely the same than on server C?

Does the linked server works with always use this security context?

Have you also checked security delegation?

Does sql server runs under the local system account or under a domain user account?

I'll be off for 2 weeks. Since you can login using a sql user the problem is with the windows validation.

I've noticed that changing ODBC-settings in normal user mode weren't...

This should do it

 Dim db As Database

  Dim rs As Recordset

  Dim sSql As String

    Dim tdf As TableDef

    Dim tdf_change As TableDef

 Set db = CurrentDb

        For Each tdf In...

Can you link tables when they are logged in?

Perhaps you can use dsn-less connections instead of using odbc-dsn's

Windows authentication connectionstring:

ODBC;DRIVER=SQL Server;

SERVER=your_server_name;DATABASE=your_database_name;Trusted_Connection=Yes

Sql server authentication connectionstring:

ODBC;DRIVER=SQL Server;SERVER=your_server_name;DATABASE=your_database_name;

UID=sql_server_login_name;pwd=your_passwd