We have an old Access database that someone created many years ago in Access 2000. They set it up with Security (companion MDW file).
We are trying to upgrade it up to Access 2007, and are unable to do so. No matter what I do, I keep getting error messages that say "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again."
I get this message if I open the Access 2000 database directly in Access 2007 and try to convert it or even compact and repair it. I also get the message if I try to run some of the commands on it, or try to "Decode it".
The database size is about 142,000 KB, so it is not approaching the 2 BG limit.
I researched it, and it looks like any number of things can cause this error.
I tried a myriad of things, such as:
- removing security
- decoding it
- cleaning up an compiling all VBA code
- deleting all data (it will not let me delete the data from certain tables, it looks like some relationships are set up)
- compacting and repairing
- importing the objects into a new database
None of this has made any difference in getting rid of those errors (as matter as fact, trying to do some of those things resulted in the error messages popping up). I still get these errors when trying to use it as an Access 2000 database in 2007, or whether I try to convert it.
Is there any way to find out what the problem is so I can convert it?
Anything like some sort of tool that will analyze a database for conversion?
Or does anyone have any advice at all?
Thanks