I get the "Cannot Open Anymore Tables" error when i try to open a particular form and a report together.
The form has 34 sub forms each of them getting data from 2-3 tables. Same is the case with the report.
Set up:
users enter the parameters and then click 'Load' button which brings up the data in the subforms on the parent form. After this if they like, the can click on the print button to print the same details in a report format. But when they do this, i get the above mentioned error.
But, if they close the form, go to "Reports" tab and open the report from there, they are able to open the reports successfully.
In Short,
users can either open the report or the form, but not both at the same time.
Can somebody please suggest me a solution.
If the solution involes updating my Service Pack for JET Driver, please also tell me about how to find which version of the driver am i using right now and which version should i update to.
Thanks a lot in advance!
Ankeet.
The form has 34 sub forms each of them getting data from 2-3 tables. Same is the case with the report.
Set up:
users enter the parameters and then click 'Load' button which brings up the data in the subforms on the parent form. After this if they like, the can click on the print button to print the same details in a report format. But when they do this, i get the above mentioned error.
But, if they close the form, go to "Reports" tab and open the report from there, they are able to open the reports successfully.
In Short,
users can either open the report or the form, but not both at the same time.
Can somebody please suggest me a solution.
If the solution involes updating my Service Pack for JET Driver, please also tell me about how to find which version of the driver am i using right now and which version should i update to.
Thanks a lot in advance!
Ankeet.