William Hindman
wdhindman at bellsouth.net
Thu Sep 4 19:02:34 CDT 2003
...the page file itself can become corrupted and is relatively easy to delete and regenerate ...been awhile but there are a number of KB articles on doing this from within Windows ...HTH :) William Hindman "the world is full of trickery. But let this not blind you to what virtue there is; many persons strive for high ideals, and everywhere life is full of heroism." ...from Desiderata ----- Original Message ----- From: "Heenan, Lambert" <Lambert.Heenan at AIG.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Cc: <bchacc at san.rr.com> Sent: Thursday, September 04, 2003 1:49 PM Subject: RE: [AccessD] Query Results Too Big? > hiberfil.sys is used by the system when you hibernate you machine (I love > hibernation, saves a bunch of time in restarting and all the proggies you > had running are back in place in one step). > > pagefil.sys is the systems virtual memory file. > > Do not mess with either of these files. You need them, but you don't ever > need to touch them. > > Lambert > > > -----Original Message----- > > From: Rocky Smolin - Beach Access Software [SMTP:bchacc at san.rr.com] > > 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 >