Can't open any more tables

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
 
J

Jerry Whittle

It could well be a memory problem. 512 mb is rather minimal. You could
upgrade one PC to 1 gb or run the database on a new computer. See if that
helps.

Your FEs are rather massive.

Have you run a good, updated virus and spyware checker on these computers?
They could be causing problems.
 
N

noreply@noreply

Mansoor is a critic of nonwarfare elements in Irak. For agency, commanders had money to money call projects and improver activities eve isk[/url:1mug2n1t] that put money in Iraqis' hands just departed.But he complains that they got far subaltern money - jillions not zillions - than "international corporations specified as Halliburton," which were work in mountainous, long-te (http://www.ugamegold.com/c_EVE-Online-ISK/:1mug2n1t)jects.
 
N

noreply@noreply

000
000000Dick was seven years old, and his sister, Catherine, was five. One day their mother took them to their aunt's house to play while she went to the big city to buy some new clothes.

000000The children played for an hour, and then at half past four their aunt took Dick into the kitchen. She gave him a nice cake and a knife and said to him, "Now here's a knife, Dick. Cut this cake in half and give one of the pieces to your sister, but remember to do it like a gentleman."

000000"Like a gentleman?" Dick asked. "How do gentlemen do it?"

000000"They always give the bigger piece to the other person." answered his aunt at once.

000000"Oh" said Dick. He thought about this for a few seconds. Then he took the cake to his sister and said to her,"Cut this cake in half, Catherine.".
* Pet products[/url:1pfkak6b], dog bed[/url:1pfkak6b], pet supply[/url:1pfkak6b], Dog Collar[/url:1pfkak6b], Dog Clothes (http://www.love (http://www.love (http://www.love (http://www.love (http://www.lovelonglong.com:1pfkak6...ak6b)ng.com:1pfkak6b)ng.com:1pfkak6b)1pfkak6b] *
 

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