>>My guess would be that the updates don't get written back to the table. Make sure you FLUSH the data. Take a look at the article on Primary Keys on my web site.
>
>
>UNLOCK automatically flushes the buffers.
>
>BOb
That's true, but server buffers are not written. For database applications to work correctly, all write caching on the server should be turned off. This is usually done via software that interfaces to the disk controller.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer