Can not open any more tables

Jun 12 2013 2:23 AM

I am having a problem in which i am trying to read record from one table and update those records into a second table ........... my query works fine for around 60-70 records. the it gives an error, can not open any more tables. I am not opening any other table except two related.

Message=Cannot open any more tables.
Source=Microsoft JET Database Engine