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...

Have you checked the consistency of the database (DBCC CHECKTABLE)?

When I had that error there were some consistency errors.

What operating system do both sql servers have?

In case of windows 2003 you have to be aware of:

http://support.microsoft.com/kb/839279

You could also try sp_updatestats on your databases (updating statistics)

A query plan on a very large table changed from a clustered index scan to an index seek

*msdb is largely a database for sql server agent, to store dts-definitions, scheduled jobs, backup history...

Sql server is quite selfconfiguring (buffers, updating statistics,recompiling,...).Chanches are that you have to tweak memory allocation...