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
Loading
Jignesh TrivediPosted Jun 12, 2013, 7:38 AM
hi,
close the connection after selecting the record and open connection again for update.
try above solution.
hope this will help you.