L
Leslie Isaacs
Hello All
I have a split FE/BE A97 mdb. The BE (278mb) is on a server, with 5 FEs
(115mb) on 5PCs: the PCs are running W2K professional, with 512mbRAM on
each.
All has been fine until this week, when one or more of the PCs has been
getting the "Can't open any more tables ..." message increasingly
frequently. Usually the process that generates this message is a function
that converts a selection of reports to pdfs. It may or may not be relevant
that, sometimes when the process appears to run OK, the PDFs themselves are
not complete: where there were numbers in boxes in the underlying reports,
sometimes the boxes are empty in the PDF.
I have compacted and repaired the FEs and the BE, and defragged the hard
disks - which all have at least 8 GB free. No other applications are running
at the time - only A97. Rebooting the PC was temporarily 'fixing' the
problem, but even this doesn't work now.
Does this sound like a memory problem? Hope someone has some ideas of what
might be going on, and/or what investigations I might do to try and get at
the problem. We're getting desperate.
Thanks for any help
Leslie Isaacs
I have a split FE/BE A97 mdb. The BE (278mb) is on a server, with 5 FEs
(115mb) on 5PCs: the PCs are running W2K professional, with 512mbRAM on
each.
All has been fine until this week, when one or more of the PCs has been
getting the "Can't open any more tables ..." message increasingly
frequently. Usually the process that generates this message is a function
that converts a selection of reports to pdfs. It may or may not be relevant
that, sometimes when the process appears to run OK, the PDFs themselves are
not complete: where there were numbers in boxes in the underlying reports,
sometimes the boxes are empty in the PDF.
I have compacted and repaired the FEs and the BE, and defragged the hard
disks - which all have at least 8 GB free. No other applications are running
at the time - only A97. Rebooting the PC was temporarily 'fixing' the
problem, but even this doesn't work now.
Does this sound like a memory problem? Hope someone has some ideas of what
might be going on, and/or what investigations I might do to try and get at
the problem. We're getting desperate.
Thanks for any help
Leslie Isaacs