troubleshooting Question

Cannot open any more tables?

Avatar of GebhartBob
GebhartBob asked on
Visual Basic Classic
4 Comments1 Solution168 ViewsLast Modified:
Problem with a VB Program Accessing an Access Database---

    Basic facts: OS is Windows 2000 Professional
                 PC has 256MB of RAM
                 Access is Access 2000 (9.0.2720)
                 Both program and Access database are local, not on network

    The VB program is a database validity check program. It originally opened some 35 tables, and it ran fine on a PC exactly the same as the one above, except it had 512MB instead of 256MB.

    When the program was run on the 256MB PC, we got pretty deep into the program (data-checked 27 of the 35 files), then got this Run-Time error:

    Error # -2147467259 (Hex 80004005)

    Error Message: Cannot open any more tables.

    Puzzled, but figuring it was a real memory problem, I spent some time cutting down the maximum number of concurrent open tables from about 35 to 14. No joy. When we re-ran the changed program, we got exactly the same result.

    Previous research I've done established that the maximum number of open connections is 63, and the maximum number of open recordsets per connection is 1022. We only have two open connections, and the maximum number of recordsets open at any one time is just 14. We have that many recordsets open in other modules, with no problem.

    Has anyone seen this error before? I'm thinking maybe an Access licensing problem, or perhaps the error message is misleading, or ... ???
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros