[AccessD] Update Query - Need to Speed It Up

What version of Access?

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
  Sent: Monday, June 02, 2003 4:47 PM
  To: AccessD at databaseadvisors.com
  Subject: [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/4c7170d3/attachment-0001.html>