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

What version of Access are you using?

Are you using ado, dao,...?

*You could add some debugging code in your stored procedure.

Like adding a new row containing some state info.

*How is your server built up? OS, sql server and patch level,...

You have a few options:

SET PARSEONLY (connection setting)

SET NOEXEC (connection setting)

SET SHOWPLAN_TEXT (connection setting)

SET SHOWPLAN_ALL (connection setting)

What they do is described in the books online (BOL)

Can you provide us some background info.

Does it happen only on your pc?

What connectiontechnology are you using?

What version of sqlserver + patch level, on what OS and hardware does it...

The command you are looking for is SELECT INTO (see the books online)

Example

SELECT Shippers.*, Link.Address, Link.City,               ...

Because sysindexes.rows,rowcnt  does not contain real-time data.

I presume it is updated with the statistics.