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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
prob....... on database closing 2
Expiration notification 4
Problem when export a report to a pdf file 1
HOW CAN I COUNT ALL THE GROUPS IN A REPORT 1
Control Source Prob.........? 1
Windows Update 0
subReport Prob 3

Back
Top