Can not open any more tables
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