Cannot Open more table

  • Thread starter Thread starter Tia
  • Start date Start date
T

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
 
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
 
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
 
Back
Top