Update Query / total number of records

[Gary W]

My system bogs down when I try to run update queries on a
large number of records at one time. I want to create a
query or queries that break this operation into smaller,
more manageable sizes.

For example, I want the query to count the total number of
records in my table and only update 1/2 or 1/4 of them at
a time. Let's say I have 100,000 records. I only want to
update 25,000 records at a time, at four different times
throughout the day. I was hoping for a solution where I
did not have to do much in the way of specifying criteria
each time I have to run them.

Any ideas for simple way to accomplish this would be
greatly appreciated. Thanks in advance!

 

[Eric Butts [MSFT]]

Hi Gary,

Only way is to specify a criteria each time. You can use TOP n within your
query and to get the reverse you could use NOT IN TOP n (not the exact SQL
Syntax just the idea) however there's not a MIDDLE number of records or 2nd
quarter of records syntax to use.

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "Gary W" <[email protected]>
| Sender: "Gary W" <[email protected]>
| Subject: Update Query / total number of records
| Date: Tue, 10 Aug 2004 07:07:15 -0700
| Lines: 15
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcR+41b0Tav+lg78TpSTtsXB0HJMYg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:209603
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.queries
|
| My system bogs down when I try to run update queries on a
| large number of records at one time. I want to create a
| query or queries that break this operation into smaller,
| more manageable sizes.
|
| For example, I want the query to count the total number of
| records in my table and only update 1/2 or 1/4 of them at
| a time. Let's say I have 100,000 records. I only want to
| update 25,000 records at a time, at four different times
| throughout the day. I was hoping for a solution where I
| did not have to do much in the way of specifying criteria
| each time I have to run them.
|
| Any ideas for simple way to accomplish this would be
| greatly appreciated. Thanks in advance!
|