table limitation

[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,

 

[Mike Painter]

You determine what tables are opened when you design the report.

 

[inungh]

You determine what tables are opened when you design the report.






- Show quoted text -

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

? Opened Tables??

 

[Mike Painter]

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

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

 

[inungh]

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 -

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,