Hi,

I have a query which updates the primary key of my table, which obviously causes flyaway - is there any way I can stop it?

It is causing my query to be extremely slow - I think!

My table contains blob images within a column and it may be re-indexing these also at the same time?

Is there a way to remove keys - run the job & rebuild all indices, without losing my blob images.

Many thanks for all advice.

DMacD

Can you give a few more details about the procedure you are using?

One thing you might consider is to work on a copy of your table. Do a general query (i.e. Check all fields) and create a copy of the table, then perform your update on the copy. After that, ADD the copy back into the original as a update.