Update query hides record using pass-thru qry?

[Lourensia]

I’m using an Access front End App that passes through 2 references in an UPDATE statement via a pass through query to a table in SQL svr 2005:

Using a simple query to change one field on a particular record and the record seems to disappear after trying to update it. Meaning if I then search for the record it returns no results. Doing exactly the same search half an hour later it then returns the record.

The update works 9 times out of 10.

Example query:
UPDATE PRINTQUEUE SET PQ_PRINTEDFLAG = 0, PQ_STATUSDESC = 'RE-PRINT REQUESTED ', PQ_STATUSDATE = GETDATE(), PQ_PRINTERID = 'pdfFactory' WHERE PRINTQUEUE.PQ_DOCUMENTNO='27036' AND PRINTQUEUE.PQ_JOBREFERENCE='G/20681' ;


Thanks. Mic

 

[genomon]

How are you "searching" for the record? If you are using VBA, try a Me.ReQuery first.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[Lourensia]

I'm searching on the Svr Management Console using a SELECT.