[AccessD] Update Query - Need to Speed It Up

Dear List:

I am running an update query on a table with 2,500,000 records and it's taking just a bit too long for the my and the client's liking.  
The SQL is:

UPDATE tblInvoiceDetail SET tblInvoiceDetail.fldInvoiceDetailPPV = """", tblInvoiceDetail.fldInvoiceDetailVariancePercent = 0;

It's setting one field to blank the other to 0.

Is there a way to make it run any faster?


MTIA,

Rocky Smolin
Beach Access Software

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030602/b04f276c/attachment.html>