Solved

Out of memory message

Posted on 2003-11-24
5
368 Views
Last Modified: 2010-05-01
I am using the VB editor that is included in Reflections to create a better interface.  Some of my users are getting an error message that simply states "Out of Memory" I am trying to clarify is this referring to the physical memory in the machine, or is there something that I am doing wrong in the coding that would cause this.  Thanks!
0
Comment
Question by:gideonn
  • 2
  • 2
5 Comments
 
LVL 10

Expert Comment

by:ADSaunders
ID: 9810355
Hi stewartje,
>My company is using the Firebox III 700.  I have never used it before.  
> How can I tell what users are doing?  
You can only tell what users are doing if they log in to the firebox security using the supplied java app. Then you can simply watch the firebox logs.
> My boss is concerned with the security.  
> Can I show him something that would indicate I am blocking the bad traffic?
Yes, run any of the log reports and print it for him.
> Can I administer this box from home using the control center software?  Or is there a better way.
Yeeesss?? But you'll be controlling a security gateway from it's untrusted network! That is if you are doing it over the Internet as opposed to a dedicated dial-in circuit.
> Does anyone know how to setup VPN with it.
Noooo.. not exactly, we needed to be shown by the support guys who installed it. we got all our requred vpns set up then. Could be asking the same question if we get a new employee requiring vpn access.

Cheers! Alan
0
 
LVL 1

Author Comment

by:gideonn
ID: 9810367
What?
0
 
LVL 10

Expert Comment

by:ADSaunders
ID: 9810380
Sorry Gideonn, was trying out quickpost, and it changed the message focus whilst I was entering my reply. It got attached to the wrong question.

.. Alan
0
 
LVL 1

Author Comment

by:gideonn
ID: 9810399
No biggie, just wasn't sure what was going on.
0
 
LVL 4

Accepted Solution

by:
Clothahump earned 250 total points
ID: 9813308
Gideonn, your problem could be a combination of both physical memory lack and coding problems.

Make sure your app specifically declares variables instead of using variants.  For example, if variable iCount is to be used as an integer, declare it so:

dim iCount as Integer

as opposed to
dim iCount

The second way will declare it as a variant and eat 8 bytes instead of 2.  Also, if you create an object, make sure you get rid of it.  For example, if you open a recordset:

dim RStest as new Adodb.Recordset
dim SQL as String
....
SQL = "select * from blahblah,etc."
call setRS(RStest,SQL)  ' I use a common function to open all recordsets - makes error trapping a lot easier

' before exiting
set rsTest = nothing
exit Sub

That sort of thing will really help manage spurious memory usage.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How does CurrentUser work? 10 31
Excel VBA, find a string in a column, update a cell 7 67
VB6 - Compare and highlight cell not the same 3 43
Add and format columns in vb6 7 47
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now