From: Armando Date: August 4 2004 9:25pm Subject: RE: Out of resources error List-Archive: http://lists.mysql.com/win32/15344 Message-Id: <004501c47a69$87605a50$71201cac@IO> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Please provide a little more information. How big is the temp. tables that are being created? What kind of resources are you running? What O/S? What about your configuration file settings? Cheers. Armando -----Original Message----- From: Leigh Sharpe [mailto:lsharpe@stripped] Sent: August 3, 2004 7:19 PM To: MySQL Win32 List Subject: Out of resources error Hi all, I'm getting the following error when using a temporary table: Out of resources when opening file 'C:\WINNT\TEMP\#sql748_c33_0.MYD' (Errcode: 24) It's a slightly terse error description. Can anybody tell me what might be causing this? Regards, Leigh Leigh Sharpe Network Systems Engineer Pacific Wireless Ph 9584 8966 Mob 0408 009 502 email lsharpe@stripped web www.pacificwireless.com.au