Using Access 2000 fully updated on Win Me with 192mb of memory. Database
opens ok but when I try to open visual basic it gives me out of memory
errors. Everything in task manager is closed. It has only been happening the
last few days after I put in some more code and forms/queries. My front end
is 17mb it is attached to a backend of about 120mb. I have repaired and
compacted the database multiple times and imported it in to a new one also.
Any other ideas besides get more memory?
Thanks,
Martin



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----

Hi:
A few questions:
1. Is the autoexec macro running anything?
If so, what.
2. In the new code you added are there any large arrays?

If 1 is true, then turn off the autoexec and see if that changes
things.

If neither is true, remove the new code. You can cut it and paste it
into a notepad fel so you can get it back.
Having done that, if the problem goes away, add the code back, one sub
at a time and see what happens.

Good luck
Ira Solomon

On Tue, 30 May 2006 11:34:48 -0400, "Martin"
<martinj (AT) schemesoftware (DOT) com> wrote:

Hi Martin, n the past, I have always found this to be the prelude to
too much code in one or more of the forms. Check your forms and see if
you can move some of the code in a module. You can usually share many
functions/sub between forms.

Kenny

Sorry, last post should have read "move INTO a module"