Erwin Craps
Erwin.Craps at ithelps.be
Thu Sep 4 11:07:25 CDT 2003
2GB limit on FAT16, not sure for FAT32 (I believe so). NTFS is no prob. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bobby Heid Sent: Thursday, September 04, 2003 5:59 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Query Results Too Big? Rocky, I'm just guessing here, but isn't there a 2GB limit on files in most OSes have a 2GB limit? If so, and Access is creating a temporary file, you may be hitting that limit. Maybe if you check your temp directory when you get that message, you'll be able to see a temporary 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 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030904/2675dfdc/attachment-0001.html>