'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?
 

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

Back
Top