Erwin Craps
Erwin.Craps at ithelps.be
Thu Sep 4 12:32:18 CDT 2003
You always have a pagefile. The files are hidden system files. If you do't turn those options on in explorer you dont see them. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Thursday, September 04, 2003 6:54 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Query Results Too Big? That's interesting. I run WinXP and I don't have either file on my system. However, we're using NTFS so if you're using FAT32, that might make a difference. WXP has a WINDOWS folder instead of WINNT. Charlotte Foust -----Original Message----- From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] Sent: Thursday, September 04, 2003 8:44 AM 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