I thought you tried to connect to your access db with odbc drivers.

1) Does your query work from the Access-database itself using the odbc connection to sql server with the...

Just a quick question.

Is the user connecting the database owner/sysadmin/...?

Thanks for posting the solution.

I assume appseq is the identity field?

Is IDENTITY_INSERT set on/off for the particular table? (see SET IDENTITY_INSERT in the books online)

What is your insert command?

The "command" is sent directly to the ODBC source without parsing from sql server.

sp_settriggerorder @triggername= 'tI_Table1' /*quotes!*/,@order= 'Last', @stmttype ='INSERT'

*second you can put SET NOCOUNT ON at the beginning of your triggers to reduce...

*You haven't put replace nor quotes in WHERE pkid = " & Me.txtpkid.Text & ""

assuming pkid is (n)varchar

*What connection technology are you using?

If VB6,Access... you can...

What is your unique constraint 'IX_budget05' ?

Welcome to the forum.

Concatenate the value behind, since the parser doesn't know the value of =aId"

Rs2.Open "Select Filename from Filename where ArticleID=" & aId

Even better would be using a stored...

Thanks for posting the issue & solution.

Are you connecting via TCP or named pipes?

Since sql server 2000 servicepack 4 you can see duplicates of processid, it has to do with parallel processing.

See http://support.microsoft.com/default.aspx/kb/906344

You could use instead of triggers.

from the books online

INSTEAD OF INSERT Triggers

INSTEAD OF INSERT triggers can be defined on a view or table to replace the standard action of...

Are you trying to reapply a servicepack since you are already running

Sql server 2000 + sql sp4?

From a certain mdac the odbc-driver for Access was dropped.

Since then you have to use the jet-driver.