table limitation

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I got message that can not open any more tables message when I print
the report.

I just wonder are there any way to see how many tables opened for the
report or totally how many tables opened?


Your information is great appreciated,
 
You determine what tables are opened when you design the report.






- Show quoted text -
Click to expand...

Yes, but they are too many.
Are there any parameter to see like

? Opened Tables??
 
inungh said:
Yes, but they are too many.
Are there any parameter to see like

? Opened Tables??
Click to expand...

I'm not aware of any but you can count them by looking at the queries that
are opened.

Are you using forms and reports with a lot of unbould tables?
 
I'm not aware of any but you can count them by looking at the queries that
are opened.

Are you using forms and reports with a lot of unbould tables?- Hide quoted text -

- Show quoted text -
Click to expand...

yes, I use unbound form and reports.
The report has many sub reports.
I got can not open more tables message from Access.

Are there any way to see how many tables open like following to se how
many controls on the report?

?Reports![name of report].Controls.Count

Thanks again,




Thanks again,
 
Back
Top