>Dmitry,
>
>Can't you get rid of buffering? Maybe that speeds up the process. Also you mentioned that the table is in the local disk, so, isn't it possible to open it exclusively for this update?
Hugo,
I have to use buffering because the update involves several tables.
I was storing the tables on my local disk just for testing. The customer is actually using the application on the network with many other users accessing the application.
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham