|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 25th, 2004, 10:16 PM
|
|||
|
|||
'Cannot open any more databases' message
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 ?!? 
|
|
#2
May 26th, 2004, 01:21 PM
|
|||
|
|||
|
'Cannot open any more databases' message
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. -- Good luck Jeff Boyce Access MVP
|
|
#3
May 26th, 2004, 05:31 PM
|
|||
|
|||
|
'Cannot open any more databases' message
It seems to occur only when I am printing reports
|
|
#4
May 27th, 2004, 03:25 AM
|
|||
|
|||
|
'Cannot open any more databases' message
David
I was only offering the observations about when I've seen that happen... Any chance your reports have any code "behind" them? -- Good luck Jeff Boyce Access MVP
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
