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.] 8 4373
"Blaine Manyluk" <bs******@corre ct.ab.ca> wrote in
news:CN6ig.2381 4$A8.22948@clgr ps12: 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/
On Fri, 09 Jun 2006 04:28:18 GMT, "Blaine Manyluk"
<bs******@corre ct.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.]
"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** ***********@127 .0.0.1... "Blaine Manyluk" <bs******@corre ct.ab.ca> wrote in news:CN6ig.2381 4$A8.22948@clgr ps12:
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.]
"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:4o******** *************** *********@4ax.c om... On Fri, 09 Jun 2006 04:28:18 GMT, "Blaine Manyluk" <bs******@corre ct.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.]
On Sun, 11 Jun 2006 18:54:55 GMT, "Blaine Manyluk"
<bs******@corre ct.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******@corre ct.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.]
"Blaine Manyluk" <bs******@corre ct.ab.ca> wrote in
news:VnZig.4007 5$S61.8099@edtn ps90: "David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message news:Xn******** *************** ***********@127 .0.0.1... "Blaine Manyluk" <bs******@corre ct.ab.ca> wrote in news:CN6ig.2381 4$A8.22948@clgr ps12:
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/
"David W. Fenton" <XX*******@dfen ton.com.invalid > wrote in message
news:Xn******** *************** ***********@127 .0.0.1... "Blaine Manyluk" <bs******@corre ct.ab.ca> wrote in news:VnZig.4007 5$S61.8099@edtn ps90: "David W. Fenton" <XX*******@dfen ton.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.]
"Tom van Stiphout" <no************ *@cox.net> wrote in message
news:q7******** *************** *********@4ax.c om... On Sun, 11 Jun 2006 18:54:55 GMT, "Blaine Manyluk" <bs******@corre ct.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.] This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 to be stored by the application. I am using TripleDES
encryption and having a very odd problem that appears to be related to a
memory management issue in the CLR. I have the 1.1 .NET Framework installed
and I am using VS.NET 2002.
I have a...
|
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 resources to help
me become familiar with pointers and referencing etc. Thank you.
|
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 "bookmarked", but all of them don't go too
far on memory management as I would like. One of my main issues
is whether function "main" and its local variables are allocated
on the stack area as other functions.
Does anybody recommend a good book or...
|
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 the memory allocated by that application is
unable to reclaim. For example, I create a DataSet object,
the application quits with a exception during debugging,
the memory the DataSet consumes will not be returned to
the system, buried within the...
|
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
a.Add(10)
Next
End If
End Sub
| |
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 notice
the memory leak. The memory usage in the TaskManager for the process
can be seen climbing and climbing, MBs at a time.
When using MemProfiler, I noticed the Win32 Heap is what seems to be
growing. I've been searching on the internet...
|
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... fourth time.. etc...)
Code is as follows...
MemoryStream ms = new MemoryStream();
Image image = new Bitmap(mainimage);
try
{
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |