473,322 Members | 1,345 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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.]
Jun 9 '06 #1
8 4356
"Blaine Manyluk" <bs******@correct.ab.ca> wrote in
news:CN6ig.23814$A8.22948@clgrps12:
Access 2000 (9.0.4402 SR-1)
Windows 2000 Server 5.00.2195 Service Pack 4
Access apps with Oracle/ODBC back ends
[]
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.


Where is the Access app being run? In Windows Terminal Server
sessions? Or on desktops? If on the desktops, then the server
configuration has zilch to do with it, but if on WTS, then you need
to look at the WTS settings. Perhaps you have insufficient RAM for
the number of simultaneous users involved.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 9 '06 #2
On Fri, 09 Jun 2006 04:28:18 GMT, "Blaine Manyluk"
<bs******@correct.ab.ca> wrote:

A few thoughts:
* The DevMode etc properties can be VERY tricky. The documentation is
not all that clear, and errors are more likely than elsewhere.
Eliminate that code for a while, and see if it makes a difference.
Also consider using Access 2002 or better, where the new Printer
object eliminates the need for them.
* Simplify the problem. For example rather than pulling the data from
Oracle, it could temporarily pull from local tables. That eliminates
an entire level of complexity.
* Run the app locally. Another simplification.
* Always run on latest service packs. I believe there is a SR-3 for
Office 2000, and there are service packs for Jet separately (SP8 I
think). Run Microsoft Update to exhaustion. The last thing you want is
bang your head against the wall and later find out MSFT fixed that
issue in a service pack.
* Run on another machine, preferably a virgin build with minimal
software installed. Printer drivers, video drivers, and fonts can be
corrupt or leaking memory.

-Tom.

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


Jun 9 '06 #3

"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in message
news:Xn**********************************@127.0.0. 1...
"Blaine Manyluk" <bs******@correct.ab.ca> wrote in
news:CN6ig.23814$A8.22948@clgrps12:
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.


Where is the Access app being run? In Windows Terminal Server
sessions?


Citrix Server, which works much the same as WTS.
Or on desktops? If on the desktops, then the server
configuration has zilch to do with it, but if on WTS,
then you need to look at the WTS settings. Perhaps you
have insufficient RAM for the number of simultaneous
users involved.


I think so too. Could there be other Citrix-based settings
that need to be adjusted for Access?

- Blaine

================================================== ====================
[To reply, remove the S's from my address, and change the R's to N's.]
Jun 11 '06 #4
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:4o********************************@4ax.com...
On Fri, 09 Jun 2006 04:28:18 GMT, "Blaine Manyluk"
<bs******@correct.ab.ca> wrote:

A few thoughts:
Thank you.
* The DevMode etc properties can be VERY tricky. The
documentation is not all that clear, and errors are more
likely than elsewhere. Eliminate that code for a while,
and see if it makes a difference.
This client *needs* that code! :)
Also consider using Access 2002 or better, where the new Printer
object eliminates the need for them.
This sounds like a very good idea. But I need to know:
- Conversion issues between A2K and A2002
- Reliability of new Printer object
(better than DevMode, but needs to be perfect)
* Simplify the problem. For example rather than pulling the data
from Oracle, it could temporarily pull from local tables.
That eliminates an entire level of complexity.
This is a large, complex, multi-user database with many
applications. All the apps are "locked" to read-only to
prevent bloating and corruption. (But this locking itself
might be the source of other problems. I really hope not.)

Local tables are hardly a practical solution. Perhaps if you
meant a temporary ADO cursor that resides in memory only not
in any files, databases or Access apps ... that might work?
Or even creating a temporary Access DB to use as a back end;
I did this to export to DBASE files while keeping the Access
app read-only.
* Run the app locally. Another simplification.
Running this system in its present form was a solution to
many other problems incurred by running it locally.
* Always run on latest service packs. I believe there is
a SR-3 for Office 2000, and there are service packs for Jet
separately (SP8 I think). Run Microsoft Update to exhaustion.
The last thing you want is bang your head against the wall
and later find out MSFT fixed that issue in a service pack.
OK, I'll suggest this.
* Run on another machine, preferably a virgin build with
minimal software installed. Printer drivers, video drivers,
and fonts can be corrupt or leaking memory.


As a test.

- Blaine

================================================== ====================
[To reply, remove the S's from my address, and change the R's to N's.]
Jun 11 '06 #5
On Sun, 11 Jun 2006 18:54:55 GMT, "Blaine Manyluk"
<bs******@correct.ab.ca> wrote:

All of my suggestions are temporary solutions aimed at narrowing down
where the problem is.
Upgrading to A2002 or 2003 is painless. Note that you can keep the
A2000 file format if you want. I don't know of any benefit not to.

-Tom.

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:4o********************************@4ax.com.. .
On Fri, 09 Jun 2006 04:28:18 GMT, "Blaine Manyluk"
<bs******@correct.ab.ca> wrote:

A few thoughts:


Thank you.
* The DevMode etc properties can be VERY tricky. The
documentation is not all that clear, and errors are more
likely than elsewhere. Eliminate that code for a while,
and see if it makes a difference.


This client *needs* that code! :)
Also consider using Access 2002 or better, where the new Printer
object eliminates the need for them.


This sounds like a very good idea. But I need to know:
- Conversion issues between A2K and A2002
- Reliability of new Printer object
(better than DevMode, but needs to be perfect)
* Simplify the problem. For example rather than pulling the data
from Oracle, it could temporarily pull from local tables.
That eliminates an entire level of complexity.


This is a large, complex, multi-user database with many
applications. All the apps are "locked" to read-only to
prevent bloating and corruption. (But this locking itself
might be the source of other problems. I really hope not.)

Local tables are hardly a practical solution. Perhaps if you
meant a temporary ADO cursor that resides in memory only not
in any files, databases or Access apps ... that might work?
Or even creating a temporary Access DB to use as a back end;
I did this to export to DBASE files while keeping the Access
app read-only.
* Run the app locally. Another simplification.


Running this system in its present form was a solution to
many other problems incurred by running it locally.
* Always run on latest service packs. I believe there is
a SR-3 for Office 2000, and there are service packs for Jet
separately (SP8 I think). Run Microsoft Update to exhaustion.
The last thing you want is bang your head against the wall
and later find out MSFT fixed that issue in a service pack.


OK, I'll suggest this.
* Run on another machine, preferably a virgin build with
minimal software installed. Printer drivers, video drivers,
and fonts can be corrupt or leaking memory.


As a test.

- Blaine

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


Jun 11 '06 #6
"Blaine Manyluk" <bs******@correct.ab.ca> wrote in
news:VnZig.40075$S61.8099@edtnps90:

"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in message
news:Xn**********************************@127.0.0. 1...
"Blaine Manyluk" <bs******@correct.ab.ca> wrote in
news:CN6ig.23814$A8.22948@clgrps12:

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.


Where is the Access app being run? In Windows Terminal Server
sessions?


Citrix Server, which works much the same as WTS.


Is this a separate product, or a bunch of add-ins for Windows
Terminal Server? I thought that Microsoft had licensed the basic
Citrix technology and used it as the basis for WTS and Remote
Desktop, and that all Citrix provided now was a set of add-on tools
for use with WTS.

Have I misunderstood?

In any event, if you're mucking around with printer settings, that
may have a problem, since there's the issue of mapping the user's
local printer to be usable from the terminal session. In WTS, Win2K
didn't do this very well, but Win2K3 has made it transparent (as
long as an appropriate printer driver is installed on the WTS). In
NT 4 Server days, you had to buy Citrix extensions to get any
printer mapping, so maybe the Citrix product you are using provides
some different methods.
Or on desktops? If on the desktops, then the server
configuration has zilch to do with it, but if on WTS,
then you need to look at the WTS settings. Perhaps you
have insufficient RAM for the number of simultaneous
users involved.


I think so too. Could there be other Citrix-based settings
that need to be adjusted for Access?


My only experience is with WTS in Win2K and Win2K Server. I've never
used any Citrix products.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jun 11 '06 #7

"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in message
news:Xn**********************************@127.0.0. 1...
"Blaine Manyluk" <bs******@correct.ab.ca> wrote in
news:VnZig.40075$S61.8099@edtnps90:
"David W. Fenton" <XX*******@dfenton.com.invalid> wrote in message
news:Xn**********************************@127.0.0. 1...
Where is the Access app being run? In Windows Terminal Server
sessions?
Citrix Server, which works much the same as WTS.


Is this a separate product, or a bunch of add-ins for Windows
Terminal Server? I thought that Microsoft had licensed the basic
Citrix technology and used it as the basis for WTS and Remote
Desktop, and that all Citrix provided now was a set of add-on
tools for use with WTS.


I do know the server is Citrix Server, and I connect to it with
Citrix Client. I'm not too sure of the exact relation between
Citrix and WTS; though my web research confirmed what you said.
Have I misunderstood?
It's Citrix.
In any event, if you're mucking around with printer settings,
that may have a problem, since there's the issue of mapping
the user's local printer to be usable from the terminal session.
In WTS, Win2K didn't do this very well, but Win2K3 has made it
transparent (as long as an appropriate printer driver is
installed on the WTS). In NT 4 Server days, you had to buy
Citrix extensions to get any printer mapping, so maybe the
Citrix product you are using provides
some different methods.


Could be.

Right now, I am going through all the reports in the apps and
setting their page setups to use Default printers. That might
make a difference; as I found out that the reports that had
the most trouble were the ones set to specific printers.
That seems to cause the most problems with the DevMode code.

- Blaine

================================================== ====================
[To reply, remove the S's from my address, and change the R's to N's.]
Jun 14 '06 #8
"Tom van Stiphout" <no*************@cox.net> wrote in message
news:q7********************************@4ax.com...
On Sun, 11 Jun 2006 18:54:55 GMT, "Blaine Manyluk"
<bs******@correct.ab.ca> wrote: All of my suggestions are temporary solutions aimed at
narrowing down where the problem is.
I think I have a better idea of that now, but thank you
nevertheless. I did try creating a new DB, importing all
the objects, and manually re-linking all the ODBC tables.
That is a common solution for Access DB/app corruption,
but it didn't help.

(see my reply to David Fenton)
Upgrading to A2002 or 2003 is painless.
My client and I will have to do that, sooner or later.
Note that you can keep the A2000 file format if you want.
I don't know of any benefit not to.


Question: If I use A2003, can I keep all my apps in A2K format,
but be able to use the Report object? Or is that feature
limited to A2K apps only?

- Blaine

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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Tony Selke | last post by:
Forgive my rather wide posting of this note, but I was uncertain of where I would find the best help. I am working on a class that is basically providing a secure location for name/value pairs...
2
by: DANIEL BEAULIEU J | last post by:
Basically i am a student taking an operating systems course which is c++ intensive. Familiar with Java, and so not so familiar with memory management. Looking for suggestions of exercises or web...
9
by: Rafael Charnovscki | last post by:
I can comprehend the basics of that subject (pointers, memory allocation, heap, stack etc), but I am interested to have references with more details. I have some C/C++ books and lots of URLs...
1
by: Welman Jordan | last post by:
When I debug an asp.net application, which would consume a considerable amount of memory, the application throws "unhandled exception" and delivers a 500 error page to the browser. I find that...
6
by: samik | last post by:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not IsPostBack Then Dim a As ArrayList, i As Long a = New ArrayList For i = 1 To 1000000...
5
by: RobbGMelenyk | last post by:
I've got a Windows Service written in C# that is having some unfortunate memory issues. I've been working with .NET MemProfiler and AllocationProfiler. But you don't have to use those programs to...
4
sujithkrishnan
by: sujithkrishnan | last post by:
Im am getting error within try block when i try to deploy in device and run it. However in emulator its working fine. In device the error is coming somtimes (when i execute that line second time......
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.