Not Enough Memory to Perform Operation

[xz0rd]

1stly sorry for the wrong post in the articles section.. (was by accident)

now i have read the thread about Access giving the error of "There isn't enough memory to preform this operation, close unneeded programs and try operation again." I also get this error. The earlier thread about this error wasn't much of a help to me. I use Access 2003 and OS is Win XP Pro i don't know whether SP3 is installed and there is a switchboard form that loads on startup.

Problem is i Have quite a few number of forms in the database and i don't want everyone to see them, thats why i created the switchboard and hid the database window on startup.

question is is there a way not to get this error and still keep working with the switchboard and not the database window?

PS: thx for the help on the earlier post got it working..

[Rabbit]

What's causing the shortage of memory? What are your system specs? Do you have any code running?

[xz0rd]

System Specs:

Win XP pro Service pack 2
P4 2.26 GHz processor
512 Ram


there is nothing but Ms Access running and the regular Microsoft system processes..and AVG Anti virus
there is no code running..(at least not that I'm aware of)

I've tried nearly everything I've put the MS access process on low priority in the windows Task manager (which still did not help) ive compacted and repaired the mdb file several times and its also set to compact on closing the mdb file is only 2MB so really don't understand... is access causing a memory leak somehow??

[Rabbit]

maybe... is the switchboard form the only thing that's open? What's on the switchboard?

[xz0rd]

ya the only thing thats open is the switchboard and on the switchboard there are hyperlinks to all the forms that the Sales staff needs during the day.

[JamieHowarth0]

Hi there,

I had this problem recently with an Access DB I was working with.

My problem specifically came about because I had copied a number of databases (with linked tables), and deleted the data from one of the linked tables.
Access, apparently, doesn't like this - when data is removed from tables, it can (on occassion) delete the relationships between tables that make up your queries.
This can lead to running a query that opens a bunch of tables, but then has no reference points with which to link the data. Access goes round and round in circles creating temporary tables, trying to find the links, until the TMP file it is using for swap space (to store the temporary tables) reaches 2GB, when it kicks up the "Not enough space/memory" error.

My suggestion - make sure all the relationships in the queries (if your queries use more than one table) are still joined together in the intended manner first (check each and every query using the Query Designer GUI). If you still get problems then let us know.

Best regards,

medicineworker.

[Rabbit]

ya the only thing thats open is the switchboard and on the switchboard there are hyperlinks to all the forms that the Sales staff needs during the day.

How many links are we talking about?

[xz0rd]

well i have about 9 links from the swtichboard

[xz0rd]

i looked into what medicineworker said and well i think he's right coz when i was creating the database it was on trial and error basis.. so i had deleted some entire tables and queries and forms... as i went along and after i ran a particular form again and closed it and opened the table it said that a query was still using it i then had to close the database and reopen it.. but i thought that after i had finished developing the database and deleted what i didnt need and only keep what needed then that problem looked kinda solved.. but apparently something is still going wrong and i'm getting this error..

i getting more clueless by the day .. and i cant have my staff facing this error when recording a sale in the showroom..

[Rabbit]

well i have about 9 links from the swtichboard

That's not much at all, wouldn't cause you to run out of memory.

Have you tried a compact and repair?

[xz0rd]

the database compacts on close every time and i compact and repair every week

[xz0rd]

would anyone like a look at the database? maybe i can give a copy for you to analyze..

[Rabbit]

would anyone like a look at the database? maybe i can give a copy for you to analyze..

We might have to go that route, let me throw it out to the rest of the experts and see what they think.

[puppydogbuddy]

We might have to go that route, let me throw it out to the rest of the experts and see what they think.

1. See this link:
http://support.microsoft.com/kb/286153


2. Another thing to try is to try decompiling/recompiling your database.

To decompile your database, follow these steps:

From the Windows, Start, Run command line, type (for example):

C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE /decompile

When Access opens, open the database you want to decompile. You may or may not see a message about VBA code. Just ignore it.

Open up any module. Compile it via Debug, Compile.., then File, Save.

Go back to the database and Compact it (Tools, Database Utilities, Compact and Repair Database)

[xz0rd]

ok now i tried running the mdb file in the respective showrooms.. and untill now they still haven't seen this error occur so now so now i'm really confused ... is there a possibility for someone to go through all i have done in the mdb file and tell me how to improve so i know that i'm not doing anything wrong on my part.. to create this type of error..

and Rabbit i thank you to offer to take a closer look but i don't know if i will be waisting your time if the error doesn't occur on the system you run it...

and about decompiling and recompiling the modules.. well.. i'm afraid to try it becoz i don't understand to much in it.. but still thank you puppydogbuddy

[NeoPa]

Let me just remind you that this site is a site of volunteers who offer their time and experience trying to help you understand and fix specific problems. This does not extend to doing your work for you nor doing general checking over of your work for you. This is a service that you should think about paying a consultant for if you need it.

ADMIN.

[chrisbryan]

Hi
Just to let you know I had exactly the same error message when trying to run acess on a new machine. Answer was install Jet 3.51 (SR3) available from ms download.

[acctinfo]

For out of memory errors or possibly any other error that prevents RL from starting on a computer using Access 2003 service pack 3 (sp3), try the instructions in Microsoft Knowledgebase article 945674 (http://support.microsoft.com/kb/945674). The solution involves downloading a hotfix from that page and installing it on the client computer.

Unzip and and save in a folder. One of the files that was unzipped is named MSACCESS.msp, you want to double-click that one and it actually installs the hotfix. You don't have to restart your computer to get going.

[NeoPa]

Thanks for the info, and welcome to Bytes!