"out of memory" problem

  • Thread starter Thread starter Jim Dunkin
  • Start date Start date
J

Jim Dunkin

I had a large database for a collection. There are over
1000 records. I have arranged them so they can be printed
as a book. Each record has a picture as part of the
data. The VBA module is set up to organize the records
and insert a page number for each record (there are 4
records per page except for perhaps the last one in a
catagory). The program worked fine up till record 1004.
I have even printed a book when I was at 980.
When I got to record #1004 and asked it to repaginate, it
errored and said there was not enough memory. Since then,
every time I access that record, all the data becomes
blank until I get out (usually have to shut down the
computer and start over). It has also given me a
message "MS access has caused an error in Kernel32DLL" and
then closes.
I have 512 mb ram and a 40 gig hard drive. Everything
else works fine. What memory is it referring to and how
do I increase it to run the program? If you need any more
information, let me know.
JIM
 
I had the same problem, I thought the machine had gone
loopy, I am resolving this now by going through my
database removing all General Modules as Access has
certain limits on modules and strings etc..If you check
help in access you will get the def's on these. My issue
was that you can only have a max of 1000 modules and I
created more but once I started deleting old redundant
modules the number has come down and the database is OK..

Hope this helps
 
Back
Top