'Cannot open any more databases' message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I got a 'Cannot open any more databases' message. I have no idea what this means. I had one database open and was printing a report
There may have been a DLOOKUP somewhere in the report, just in case thats a factor
Anyone got any ideas, it sounds serious ?!?
 
David

This can happen if your application opens recordsets and doesn't close them
(I suspect these are the "databases" mentioned in the only marginally useful
error message). I seem to recall another potential cause, if you have code
that doesn't explicitly test for a value of a checkbox field in an If...Then
statement.

Try also checking Google.com in the MS Access group with that message as
your search term.
 
David

I was only offering the observations about when I've seen that happen...

Any chance your reports have any code "behind" them?
 
Back
Top