Memory management problem?

Greetings...

I have some strange problems involving:

Access 2000 (9.0.4402 SR-1)
Windows 2000 Server 5.00.2195 Service Pack 4
Access apps with Oracle/ODBC back ends

One app is a reporting one, and it opens reports (in either
View or Print mode) from a master form. The code opens the
report first in Design mode, applies some changes to DevMode,
DevName, and Mip properties, then reopens the report for
View or Print. Any trouble happens on the last step.

The app usually runs fine for a while (2-5 reports), then
fails to open reports, and generates some strange error
messages:

2759 - The method you tried to invoke on an object failed
2455 - You entered an expression that has an invalid reference
to the property Inputparameters.
2465 - Access can't find the field "" referred to in your exp
2100 - the control or subform is too large for this location
? - The expression On Activate you entered as the event
property setting produced the following error:
Can't execute code in break mode.
? - Unknown Jet Error

All these point to "out of memory".

Note that even after this problem happens, I can still manually
open the reports all the time, and sometimes open them with
the master form and Devmode code. The app seldom crashes
completely, or needs to be closed and restarted.

I religiously repair and decompile all my apps. I haven't
(yet) done the laborious process of creating a new app, and
importing all objects, and relinking all ODBC tables. That
is my last resort. My code also sets objects to Nothing
when finished with them. None of these reports have large
image objects.

Another possibility is trouble with my Windows-level temp
directory. This app runs on a large server with huge amounts
of both RAM and disk space. Perhaps there is some setting
that I (and the server admin) have overlooked.

Any ideas?

- Blaine

======================================================================
[To reply, remove the S's from my address, and change the R's to N's.]


.

Relevant Pages

  • Re: LINE_NEWCALL during TSPI_lineOpen or TSPI_lineSetDefaultMediaDetection
    ... >> example put in by a server application that had the line open on the ... If a second app now opens the line it can get the existing ... > one "app" is running remotely on the client). ...
    (microsoft.public.win32.programmer.tapi)
  • Re: Cannot open a project
    ... > I have a dotnet web app that opens & works fine. ... > There's another application on the same server, in a folder below the web ... > work on the server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Cannot open a project
    ... I have a dotnet web app that opens & works fine. ... There's another application on the same server, in a folder below the web ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: LINE_NEWCALL during TSPI_lineOpen or TSPI_lineSetDefaultMediaDetection
    ... > example put in by a server application that had the line open on the ... > Andreas Marschall wrote by having an own tapi app running that already has ... If a second app now opens the line it can get the existing ...
    (microsoft.public.win32.programmer.tapi)
  • Re: Memory management problem?
    ... The DevMode etc properties can be VERY tricky. ... Run the app locally. ... One app is a reporting one, and it opens reports (in either ...
    (comp.databases.ms-access)