Erwin Craps
Erwin.Craps at ithelps.be
Thu Sep 4 12:31:09 CDT 2003
For wxp check C:\windows\temp and C:\documents and settings\[YOUR_USER_NAME]\Local settings\temp Delete everything in those temp folderS. But if your disk was NTFS formatted you should not the file quantity limit problem. But anyway make those folders empty. Pagefile.sys is your windows swap file, that you need and can not may not delete. Hyberfile is needed when your computers hybernation is activated. That not sleeping (stand bye) mode but rather freeze mode... If you hibernate your pc your RAM is written to disk, no power comsumption at that time. In stand bye mode your RAM is still getting power to substain the dat in RAM. All other activities are stopped or put to a low level. Hybernate is not of much use on a fix desktop. You can turn hybernating of in the power setting of your control panel. The hybernate file will be automaticly deleted, saving space on your disk. The hybernate file has the +/- same size as your RAM. Erwin -----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 6: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