Bobby Heid
bheid at appdevgrp.com
Thu Sep 4 12:46:56 CDT 2003
And to expand on what Charlotte said... If you move the page file to another physical drive not on the same EIDE channel, you can realize a performance increase. It helps if the page file is the only file that uses that partion on that drive. I always set up my machines that way with a dedicated partition on another drive. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, September 04, 2003 1:31 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Query Results Too Big? The page file can be changed by going to the System applet in the control panel and selecting the Advanced tab. Click on Settings for Performance Options, then select the advanced tabin the dialog. The bottom section is Virtual Memory, and the Change button will allow you to resize the paging file. If you have multiple drive, you can put a small paging file (2MB) on C: and put a larger one on D:. Charlotte Foust -----Original Message----- From: Bobby Heid [mailto:bheid at appdevgrp.com] Sent: Thursday, September 04, 2003 9:15 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Query Results Too Big? I don't think that you CAN delete the page file from within windows. Nor do you want to. It is a file that the OS uses during its operation. I am not sure about the other file. Bobby -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, September 04, 2003 12:59 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query Results Too Big? Do you know if they can they be deleted? Rocky ----- Original Message ----- From: "Bobby Heid" <bheid at appdevgrp.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Sent: Thursday, September 04, 2003 9:49 AM Subject: RE: [AccessD] Query Results Too Big? > One is your paging file, the other must store system data when hibernating. > > Bobby > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin - Beach Access Software > Sent: Thursday, September 04, 2003 12:44 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Query Results Too Big? > > > I'm using WXP and I don't see a WINNT folder. But I do see two files named > hiberfil.sys and pagefil.sys which, together are almost 1GB. Any idea what > they are? They were updated this AM when I turned on the machine. > > TIA > > Rocky > > ----- Original Message ----- > From: "Erwin Craps" <Erwin.Craps at ithelps.be> > To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> > Sent: Thursday, September 04, 2003 9:05 AM > Subject: RE: [AccessD] Query Results Too Big? > > > > This could be an os problem to... > > > > Check if in you temp folder (usualy c:\temp or c:\winnt\temp or > > c:\windows\temp and/or C:\Documents and Settings\[USERNAME]\Local > > Settings\Temp) you have a lot of temp files. > > Delete everything in there (first close all apps). > > > > When using W9x you have a maximum of x files in a folder. It is > > posible that you have to much lost files. > > > > I can also be a disk corruption. Scandisk your drive after deleting > > those temp files. > > > > And while we are on the road, do a defrag... > > > > Erwin > > > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, > > Lambert > > Sent: Thursday, September 04, 2003 5:54 PM > > To: 'Access Developers discussion and problem solving' > > Cc: 'bchacc at san.rr.com' > > Subject: RE: [AccessD] Query Results Too Big? > > > > > > Check these kBase articles. They might address your problem > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;209940 > > http://support.microsoft.com/default.aspx?scid=kb;en-us;286153 > > http://support.microsoft.com/default.aspx?scid=kb;en-us;161329 > > > > They all talk about the same problem, exceeding the MaxLocksPerFile > > value and how to fix it. > > > > Lambert > > > > > -----Original Message----- > > > From: Rocky Smolin - Beach Access Software > > > [SMTP:bchacc at san.rr.com] > > > Sent: Thursday, September 04, 2003 11:23 AM > > > To: Access Developers discussion and problem solving > > > Subject: Re: [AccessD] Query Results Too Big? > > > > > > Jim: > > > > > > I've got 3 1/2 GB free. That enough? Must be if the 2GB Access > > > db limit is any indication. If the temp tables holding the query > > > results > > > > > are inside the db then quite possibly is hitting the Access limit > > > without using up all the hd space? It's a select query. > > > > > > Regards, > > > > > > Rocky Smolin > > > Beach Access Software > > > > > > > > > ----- Original Message ----- > > > From: Jim Dettman <mailto:jimdettman at earthlink.net> > > > To: Access Developers discussion and problem solving > > > <mailto:accessd at databaseadvisors.com> > > > Sent: Thursday, September 04, 2003 7:51 AM > > > Subject: RE: [AccessD] Query Results Too Big? > > > > > > > > > Rocky, > > > > > > << > > > I have a query which is the record source for a report which > > > eventually craps out with the message 'Not enough space on > > > temporary disk' or some such. The query is joining 2 tables which > > > each have over 2 million records. > > > >> > > > > > > What type of query is it? If it's creating a snapshot of the > > data, > > > then you could easily run out of disk space. How much free space > > > do you have on your drive? I've done queries with 1,500,000 > > > records without problems. > > > > > > << > > > Is there a limit to how big a query result Access can generate? > > Is > > > there a setting to increase the limit? > > > >> > > > > > > The only one I'm aware of is the 2048 table reference limit > > and the > > > fact that it must "compile" (Microsoft's term not mine) into a > > > memory space slightly larger then 64K (they have never said how > > > much larger). > > > > > > 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: Thursday, September 04, 2003 10:39 AM > > > To: AccessD at databaseadvisors.com > > > Subject: [AccessD] Query Results Too Big? > > > > > > > > > Dear List: > > > > > > I have a query which is the record source for a report > > which > > > eventually craps out with the message 'Not enough space on > > > temporary disk' or some such. The query is joining 2 tables which > > > each have over 2 million records. > > > > > > Is there a limit to how big a query result Access can > > generate? Is > > > there a setting to increase the limit? > > > > > > I think I may have reached the limit of Access and am > > looking now > > > for other ways to give the user what they want. Short of going to > > > MSDE. > > > > > > TIA > > > > > > Rocky Smolin > > > Beach Access Software > > > > > > > > > > > > _____ > > > > > > > > > > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > << File: ATT7209042.txt >> > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com