'Cannot open any more databases' message

D

David

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 ?!?
 
J

Jeff Boyce

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.
 
J

Jeff Boyce

David

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

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