HELP- isn't enought memory to perform the operation?

  • Thread starter Joe He via AccessMonster.com
  • Start date
J

Joe He via AccessMonster.com

I am trying to convert a Access97 front end db to Access 2002 format.
I build a new Access2002 db1.mdb
then I tried to mporting all table/forms etc to db1.mdb
most of the object correclty imported, but some forms have exception says "There's isn't enought memory to perform the operation...."
one of the form is really simple with only one label in it without any code.
Any one has pointer or advise how to deal with the problem? I have been working on it for quite a few days without any lucky.

I have both Access2002 and Access97 installed on my desktop, which is running Win2000. I have 1.25G memory (upgraded from 512M for the problem but didn't help)

Thanks for any help!
Joe
 
A

Allen Browne

How many modules are there in this application, including any modules in
forms and reports? From memory, A97 supported 1024, but later versions allow
only 1000, so if you are chockers that may be the cause of the error.

If that is not the case, the error may be triggered by an incipient
corruption. Use Access 97 to decompile a copy of the database by entering
something like this at the command prompt while Access is not running. It is
all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"
Then compact the database, and try again.


If that still fails, you could work the other way around:
1. Create a new database in A2002.

2. Uncheck the boxes under:
Tools | Options | General
Explanation of why:
http://members.iinet.net.au/~allenbrowne/bug-03.html

3. Import everything from the old database:
File | Get External | Import

4. Open a code window, and choose References from the Tools menu.
Remove any references you don't need, and check the box beside:
Microsoft DAO 3.6 Library
More about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

5. Still in the code window, choose Compile from the Debug menu.


If that still fails, you could see if the converter tool can tell you what's
wrong:
http://office.microsoft.com/search/redir.aspx?AssetID=XT011424581033&Origin=HH011710251033&CTT=5
 
J

Joe He via AccessMonster.com

Allen, Thank you for the detailed reply.
I have about 300 reports, forms and 300 tables queries 20 modules.I tried a few and finally I find that the /decompile does not work. I have to manully touch the object and 'compile and save'. but it worked.

However, One reports used in the application does not appear in the report catagory but all others. its name is ACCT_COM_EXP_SUM. if I run the app, when I saw the form I can enter design mode and the window indicates ACCT_COM_EXP_SUM:Report, however I am sure it is not in the reports. any idea what is happening?

thank you!
 
J

Joe He via AccessMonster.com

another question is, when you decompile, which version of Access should I choose? I have both 97 and 2002 installed.
Thank you
Joe
 
A

Allen Browne

Okay, so one report was corrupt, and you have retrieved all the others.
That's good.

Using the original version, try:
SaveAsText acReport, "ACCT_COM_EXP_SUM", "C:\Acct.txt"
If it's badly corrupted that won't work. If that works, you could then
import into the new versoin with:
LoadFromText acReport, "ACCT_COM_EXP_SUM", "C:\Acct.txt"
 
D

Douglas J. Steele

Whatever version corresponds to your database. If it's in Access 97 format,
use Access 97. If it's in Access 2000 or Access 2002 format, use Access
2002.
 
J

Joe He via AccessMonster.com

I made a lot progress ahead with your help : )
Now I found out the disappeared A* reports is a hiddend objects. I can see some more object come out after 'show hidden ojbect'. Interesting.

However, after I turned on my hidden objects, the db won't compile anymore enven in Access97 version. According to the experienced user, some of the forms are developed in Access 95. And because it is hidden, it is forget by both the people and Access system since 1995.

current problem is that I cannot delete or access the code of the old hidden object, say form QueryMenu. I can view it and open it in design view, but I can NOT delete and view it's code (because it is not VB code I guess).

Now I have a Access97 DB with a few 95 objects inside. and I don't have Access95 or the older version of the DB. Any suggestion I could get around the probme to compile the database in Access97?

Thank you.
 
J

Joe He via AccessMonster.com

a few more words: I need to do this is to get my ACC_* reports out. If the db compile won't pass the old 95 objects. what can I do?
 
A

Allen Browne

If the objects are valid, you will be able to export them with SaveAsText.

If you want to get rid of them, create a new (blank) database, and import
all the valid objects.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top