[AccessD] Query Results Too Big?

Charlotte Foust cfoust at infostatsystems.com
Thu Sep 4 11:54:04 CDT 2003


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


More information about the AccessD mailing list