Mark A Matte
markamatte at hotmail.com
Mon Apr 17 09:24:49 CDT 2006
Doug,
Not sure if this is relevant...but last year...I had a similar issue where
my forms and queries would run fine...but would occasionally give me the
'memory' error when trying to modify. I didn't spend much time on the
problem...because it was my A97 dbs that were only having the issue after I
loaded A2k on the same machine. I had both versions on a box with W2K
Server...and it worked fine. When I put both versions on WXP...I started
having the 'Not Enough Memory' when I tried to do things in A97...I just
quit using 97 on that machine...so I don't really have a solution or
suggestion...just thought I'd mention it ion case it gives someone an idea.
Good Luck,
Mark A. Matte
>From: "Doug Murphy" <dw-murphy at cox.net>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] There isn't enough memory to perform this operation.
>Date: Sat, 15 Apr 2006 14:40:54 -0700
>
>Hi Marty,
>
>I have already attempted the export and import to/from text file. I was
>not
>aware of the print to SQL functionality of DAO. I tried this and it gave
>me
>the SQL of the query which is very cool. I am putting this in my list of
>tools. I tried copying the SQL from the debug window and pasting into a
>new
>query. Still get the out of memory message. I will play with the SQL to
>see if I can find what is causing the problem.
>
>The problem database does some very involved statistical calculations with
>many queries and a lot of code. The problem is that no naming convention
>was used and field and object name structure is bazaar. There are quotes,
>spaces, parens, etc in the names. This may be the source of the problem.
>As I go through the project I have been updating naming, but in many cases
>where the existing name doesn't contain any unusual characters or spaces I
>am leaving as is. Each change, using Speed Ferret, takes significant time,
>so to change the name of several thousand objects is not feasible.
>
>Thanks again.
>
>Doug
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
>Sent: Friday, April 14, 2006 10:12 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [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
>
>
>
>--
>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