For sql server 2000 it is best to patch to service pack 3a or higher, this to fix many bugs.

By applying the service pack there is also a great chance...

@@Servername is not null?

Have you applied any sql server service packs?

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?