Cannot Open more table

[Tia]

Dear all,

I have a form with 11 subform, withdynaset constent update all of them
are viewed as datasheet
once i click on any of these subform i receive cannot open more
tables, how many subform i can open in a form and how can

 

[Gina Whipp]

Tia,

It's technically not the subforms problem. It is a table problem... What
version of Access and do you have all your patches installed?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tia]

I am using access 2007 all of these subforms are in one form every
time I'm making any data entry I'm receiving cannot open anymore
tables m
How can I know what's the problem

 

[Gina Whipp]

Tia,

Is the RecordSource of your subforms queries? If yes, approximately how
many tables per query? I think you have to open ALOT of tables to get that
message, like 2,000. What size is your database? Try running Compact &
Repair and see what happens then.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm