Prob.......

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

I am getting an error message saying Cannot open more
tables after opening same report for 3 to 4 times. How to
solve this problem. Please help. Thanks in advance
 
Krish:

Look in your report. If you have a lot of DLookUp, DSum, DCount calls, then
try to replace those with actual recordsets opened and closed in code. This
is because those functions open an instance of the db tables in the
background and they can sometimes not get closed appropriately, leading to
the error you are receiving.
 
Back
Top