Charlotte Foust
cfoust at infostatsystems.com
Thu Sep 4 13:31:03 CDT 2003
Not necessarily. Charlotte Foust -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Thursday, September 04, 2003 10:02 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query Results Too Big? Guess I'll just leave those two files alone. Actually wouldn't performance be enhanced the larger the swapping file is? Rocky ----- Original Message ----- From: "Charlotte Foust" <cfoust at infostatsystems.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, September 04, 2003 10:31 AM 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 > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com