Erwin Craps
Erwin.Craps at ithelps.be
Thu Sep 4 11:05:58 CDT 2003
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