[AccessD] Query Results Too Big?

Mwp.Reid at Queens-Belfast.AC.UK Mwp.Reid at Queens-Belfast.AC.UK
Thu Sep 4 13:11:05 CDT 2003


Rocky

Youcantry thisbutIhavenoideawhat happens(<:

You'll need to turn off the "Enable Hibernate" by going to: 

Start->Settings->Control Panel->Power Options and then select the "Hibernate" 
Tab and De-Select the "Enable Hibernation" check box.

After you do this WinXP will delete the hiberfil.sys file next time you re-boot.

Martin



Quoting Rocky Smolin - Beach Access Software <bchacc at san.rr.com>:

> 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
> 


More information about the AccessD mailing list