[AccessD] There isn't enough memory to perform this operation.

Try this to save query to a text file
Application.SaveAsText acQuery, "MyQuery", "c:\temp\myquery.txt"
then in a new mdb
Application.LoadFromText acQuery, "Catalog", "c:\temp\myquery.txt"
The text file will be the QBF definition not the actual SQL string
if you want that try
Sub test()
Dim db As DAO.Database
Dim qdf As QueryDef
Set db = CurrentDb
Set qdf = db.QueryDefs("MyQuery")
Debug.Print qdf.SQL
End Sub

Max Home wrote:

>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
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada