Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Thu Sep 4 09:38:31 CDT 2003
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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030904/6137aba2/attachment.html>