Max Home
max at sherman.org.uk
Fri Apr 14 16:42:50 CDT 2006
Doug, try exporting the query as a text file and then re-importing it from a text file (docmd.transfer something or other - look it up). That should clear any embedded problems. OR - open another DB and import it into that (but link the tables it uses first so that the import function *finds* the tables it refers to). Both these work for me from time to time. Regards Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: 14 April 2006 22:32 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] There isn't enough memory to perform this operation. Hi Jim, I am working in Access 2002. The query runs, I just can not open in design view. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Friday, April 14, 2006 2:16 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] There isn't enough memory to perform this operation. Hi Doug: Depending what version of Access you are using there is a strict size limitation to queries. On older versions, like A97, you would have to breakup to query into sub-queries that would be accessed from caller query as if they were tables. Another way to handle complex queries was to move as much of the query as possible into a function, in a module and call the function from the query. This may not be your situation but it was one of the main issues with older versions of Access and queries. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Friday, April 14, 2006 1:55 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] There isn't enough memory to perform this operation. Folks, I have a legacy database I am trying to update for a client. When I try to open one of the queries in design view I get the message "There isn't enough memory to perform this operation. Close unneeded programs and try again." I have tried opening the query on two different computers and get the same result. From where the query is being used I know it uses the values of 14 different controls on a form as criteria. I exported the query to a text file and it really does not look that complicated, but access is having trouble showing it in the query design window. Any suggestions on how I can work on this thing? Thanks in advance for your thoughts. Doug -- 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