Cannot open a form in Access 2000

[Guest]

I have a database in Access 2000 which has been working well. However, when
I tried to open the forms I got the message "There isn't enough memory to
perform this operation. Close unneeded programs and try the operation
again".

I deleted files in the drive it is located and the C:\drive but this has
made no difference.

Has anyone come across this before and how was it resolved?

Many thanks.

 

[Avlan]

Have you tried downsizing your form, see if/when it opens?

Deleting files is useless since the problem seems RAM-related, not
harddrive related. You need to close running processes to free
RAM-memory. How much RAM-memory does your PC have?

What's your configuration anyway? Windows 2000? How old is your
computer, what are the hardware specs? Pentium 3 with 64MB RAM memory?
etc.

 

[Guest]

I cant open any forms so would be unable to downsize. I don't think the
problem relates to the size of my RAM because it is saved on the H: drive
which is connected to a very large server (I work in the public sector). I
also have lots of other databases on this drive. I have Windows 2000
Professional and my computer is about 5 years old with a Pentium 3.

Cheers
Ritabix

 

[Guest]

have you tried opening the form in design view, how about repair and compact

 

[Guest]

Yes Phil, I've tried both suggestions but neither work. I still get the same
message.

Thanks anyway.

 

[Guest]

Yes Phil, I've tried both suggestions but I still get the same message.
Thanks.

 

[Guest]

Yes Phil, I've tried both suggestions but I still get the same message.
Thanks.

 

[Avlan]

I cant open any forms so would be unable to downsize. I don't think the
problem relates to the size of my RAM because it is saved on the H: drive
which is connected to a very large server (I work in the public sector). I
also have lots of other databases on this drive. I have Windows 2000
Professional and my computer is about 5 years old with a Pentium 3.

Cheers
Ritabix

It doesnt matter where the database is stored, if YOU open it on YOUR
computer its YOUR computers RAM that counts. Your computer, after all,
has to start Access, not the server.

Have you checked how many free memory you actually have before you open
the database? Maybe there's a process that munches up a lot of your
resources.

 

[Guest]

The computer's RAM is 64MB but I don't see why only this particular database
is the problem and not all the others too. How do I check the memory is it
just the hard drive C:\ and D:\ drive?

 

[Avlan]

C:\ and D:\ are the harddrives, but harddrives are usually not referred
to as 'memory', and anyways, the size of C:\ and D:\ should not
matter... Check C:\ just to be sure, you can see the amount of free
disk space in windows explorer.

I'm not sure how it could be just one database, but it could be that
the database is much bigger then the others, containing a lot of
modules and macro's, taking a lot of memory, I don't know. You could
compare a working database's size on disk with the size of the failing
one.

 

[Arvin Meyer]

When I see that error, it is almost invariably because of graphics on the
form. It can happen because of low resources even with high memory video
cards. Make a copy of the database, compact it, open the form in Design View
and remove any graphics. If that fixes it, you'll know the culprit.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Hi Ritabix,

Try using Windows Explorer to copy the database from the H: drive to your
local C: drive. Can you open a form now?

If not, try creating a brand new database, and then import all objects from
the suspect database into the new database. Can you open a form now?

Notes:
1.) During the import operation, it is best to import each group of objects
seperately. In other words, import all tables, then all queries, then all
forms, etc.

2.) You will need to verify that the checked library references match
between the source database and the new database. Hit ALT F11 to open the
Visual Basic Editor. Then click on Tools > References. Do this first in the
database that is not working properly. Make a note of which references are
checked. Repeat this procedure in the new database. Make sure that the same
references are selected, and for the present time, it's best to make sure
that they are in the same order.

3.) You'll also need to reset any startup options specified under Tools >
Startup.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?" at the bottom of the message thread.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have a database in Access 2000 which has been working well. However, when
I tried to open the forms I got the message "There isn't enough memory to
perform this operation. Close unneeded programs and try the operation
again".

I deleted files in the drive it is located and the C:\drive but this has
made no difference.

Has anyone come across this before and how was it resolved?

Many thanks.

 

[Mastercafe - Juan]

Try to do this:
Open a new MDB and import all from the Old Mdb
Open the new MDB go to Modules, and close all windows from code.
Compile the new MDB and try to use.

Sometimes this error appear on pc's with a lot memory, and the problem is
that when you open the source of each form, the memory reserve a part for
this. Then on an application with 50 forms, you can open 50 windows with
source code (in VBA) and then there are not memory to perform anything.
Another comment 64mb de RAM is to low memory to develope or manipulate soma
MDB. You are using continuosly your HDD, increase the size for the temporary
ram.

--
Saludos desde España

Juan
Mastercafe S.L.
www.mastercafe.com
(e-mail address removed)

 

[Guest]

Thank you Avlan, Arvin and Tom.
I will try out your suggestions and get back to you via the Discussion Group.
Cheers.