>I have at this moment a table with 4 fields , two of them are key fields. This table contains information about questionaries identified by an internal counter. I'm using an updateable local view but it is getting too slow when the update is made taking about 10 seconds in a PII 233Mhz PC - it has about 100,000 records at this moment.
>
>Does anyone know what can be done ?
Perhaps this will get faster if you update on key fields only. See the update page of the view designer.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)