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 ... ???