I developed an application using Access 2000 which runs fine. I tried to run the application on an xp machine using Access 2002 and about half way through the application, I got the Error 3014, too many tables open.
I check Google for the Error Code (3014) and found that there may was a problem with jet 3.5. The site that I found had a patch.
Access 2002 was using jet 4.0, but just to be safe I installed jet 3.5 and used the patch.
I still have the problem.
I have checked all of my code and I close every recordset that I open whenever I am not needing it open.
I do have a few DLOOKUP's - is this opening tables?
After the application bombs, if I try to run it again, it immediately gives me the error message.
My questions are as follows:
1. Do DLOOKUP's open tables? if so how do I close them.
2. Is there any debugging feature where I can tell what tables are open?