I am developing a C++ app using VC++ 4.0, the DAO SDK, and Access 95.
After the app is running for a while, I get an exception when trying to
run a query.  The error is 3014 - Can't open any more tables.

Q. Has anyone had this problem ?

Q. What is the limit to the number of tables open ?

Q. How can you check how many tables are open ?

Any help would be appreciated

Regards

Mark Flannery

It's just a guess, but often this will happen if you are open
recordsets inside a large transaction. The recordsets, even it they
are properly closed in the transaction, get cached until the
transaction is committed, and eventually you hit a limit. I do not
know what exactly the limit is.

If this is it, you can try restructuring the code to use fewer
recordsets, or you could try doing commits more frequently -- say,
every 500 or 1000 loops.

 -- Andy