[AccessD] Update Query - Need to Speed It Up

A2K
  ----- Original Message ----- 
  From: Jim Dettman 
  To: accessd at databaseadvisors.com 
  Sent: Monday, June 02, 2003 1:56 PM
  Subject: RE: [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




------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030602/f10fa5db/attachment-0001.html>