Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
This only works with ACCDB, not with ACCDE.
Error: Cannot open any more databases, Access 365
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
Hello,
I made a database in Microsoft Access a few years ago (Microsoft Office XP) and now that I am running the latest version of Office (365), whenever I try to print the report of this database I get an error saying "Cannot open any more databases". When I click on OK, the error appears again and if I click on OK repeatedly for quite a few times, the error dissapears and then if I click on Print Preview, I can see and print the report.
I googled the error and saw that it comes mainly from coding mistakes. However, I used to be perfectly able to print the report of this particular database in older versions of Office (XP).
Could you please tell me what to do in order to not have to spend a minute or more clikcing on OK so that the error goes away?
Thanks
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
7 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Duane Hookom 26,825 Reputation points Volunteer Moderator2019-08-29T13:13:33+00:00 Does your report contain lookup fields/combo boxes?
-
Anonymous
2019-08-29T09:16:14+00:00 When the error pops up, and you hit Ctrl+Break, does that break into the debugger from where you can find out what's causing it?
Hello and thanks very much for your reply (and sorry for the delay - was on holiday).
I tried hitting Ctrl + Break but it does not enter the debugger. What could be the problem?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 41%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETV%3C/text%3E%3C/svg%3E)
Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator2019-08-03T21:20:37+00:00 When the error pops up, and you hit Ctrl+Break, does that break into the debugger from where you can find out what's causing it?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
ScottGem 68,830 Reputation points Volunteer Moderator2019-08-03T17:18:06+00:00 Hi Iraklis, I'm an independent advisor and will try to help.
Each version of Access has tightened up on VBA code so code that might have worked fine in older versions may cause problems in newer ones. So I'm not surprised that an app originally written in XP would have issues with the latest version.
You really need to update this app to the latest version (accdb). Then you need to step through the code, seeing what lines of code are causing the errors and fix them. If you need help with doing so, show the lines causing the errors and we will try to help.