Jim Lawrence
accessd at shaw.ca
Fri Apr 14 19:50:15 CDT 2006
Doug: Oh, Would it be a security setting? Queries can be set to allow execution but not reading. 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 2:32 PM 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