Updated subject: Query failing to execute WAS: RE: [AccessD] Combobox question UPDATE

Hi Bobby

Dropping/recreating indices is mainly used when _appending_ large
amount of data to large tables. Perhaps that is what you had in mind?

/gustav


> Thanks for the reply.

> I deleted the indexes because I thought that they might be slowing it down
> with so many records being updated.

> There are usually between 5000 and 50000 payroll records.  But even on the
> other larger databases, it did not take very long.

> Thanks,
> Bobby

>> -----Original Message-----
>> From: Heenan, Lambert [SMTP:Lambert.Heenan at aig.com]
>> Sent: Wednesday, June 30, 2004 4:44 PM
>> To:   'Access Developers discussion and problem solving'
>> Subject:      RE: Updated subject: Query failing to execute WAS: RE:
>> [AccessD]  Combobox question UPDATE
>> 
>> My 2 cents worth.
>> 
>> 1/ Removing the indexes is a sure fire way to slow things down.