Max Home
max at sherman.org.uk
Fri Apr 14 17:13:39 CDT 2006
Doug, that just doesn't make sense. Either you have something wrong with you installation of Access (try importing it as a txt file on another machine if possible) or open it with notepad and then save it again having made some alteration so that it actually saves a new version. If it runs but doesn't open for edits then that is so weird. Another thing you could try is to create a new DB and import it and THEN create a new form with that as the recordsource and then create a command button from the wizard selecting the option to filter by form - there are two wizards there, so try them both. If no success, then open it in notepad, select all (Ctl-A) and then on the new DB create a new query, select nothing, click on SQL on the toolbar and paste it into that, before running it, select the option for design and see if it opens. Regards Max Ps. Although this has come from my home email address, please reply to my work Email address (max.sherman at mga-charity.org) as I will still be picking up my email -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: 14 April 2006 22:56 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] There isn't enough memory to perform this operation. Hi Max, Did both of these and still can not open the query in design view. I seem to remember something about there being a limit on the size of queries, but have not found anything specific. I think I'll just rebuild the query as Jim suggested in a more user friendly manner. I think I can get the form to work much better this way. Thank you for your thoughts. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Home Sent: Friday, April 14, 2006 2:43 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] There isn't enough memory to perform this operation. 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 -- 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