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

Could be of a connection setting implicit transaction on/off. Sure that any begin transaction has a matching rollback or commit transaction statement?

Have you checked your stored procedure with microsoft best...

surely

CREATE PROCEDURE dbo.USP_BATCH

AS

EXECUTE dbo.USP_BATCH_START

EXECUTE dbo.USP_BATCH_MIDDLE

EXECUTE dbo.USP_BATCH_CLEANUP

Can you post the full content of filteringstr?

debug.print filteringStr

a guess

if Me.Discharged_.Value = 0 then

if filteringStr="" then

filteringStr =qryNotDischarged.Discharged=0

else

filteringStr = filteringStr & " AND qryNotDischarged.Discharged=0"

end if

else

end if

The added latency could have increased the time the locks are held. Do you close your recordsets as soon as possible?

Is it possible to have the printing done not by...

You can also figure it out with sp_who,sp_who2,sp_lock.

The client tools version matches the sql server version (in terms of servicepacks)?

Have a look at http://www.connectionstrings.com/ for all possible connection strings.

Things to check:

Servername htm is known on the other pc.

Is your sql server configured for windows or mixed mode? If windows...

Care to elaborate a bit?

Is this about using the identity datatype or using a default value?

Have you checked security delegation for the linked servers?

A guess in the dark, have you rebooted the machines to make sure that MSDTC is started before sql server?

The windows servers have...