Cannot open any more databases

[Programmer - wannaB]

This is a huge problem, that I need to get fixed fast. I would really
appreciate any help. I have Jet 4.0 SP8, Access2003 SP2, WinXP Pro SP1. I'm
Not able to change any of those things. I took an access 97 database SPLIT
it and imported all Other objects that were needed into Access 2003. Backend
is access 97 front end is access 2003. Everything seemed to go just fine,
put this out in test and everything seemed to work fine. Moved to production
and not there are problems - Print Preview of complex reports looks just
fine, until you look beyond the 5th page, then the data is not all there, and
when the report is printed from preview there are 2 errors that come up many
times, the first "Cannot open database. It may not be a database that your
application recognizes, or the file may be corrupt." That appears with an OK
and HELP button and returns after clicking OK about 6 times, the second
message "Unrecognized database format \\PATH\FILENAME."
I expected this might be due to access97 as a backend, so I've been testing
with an access 2003 backend and Printing still has the same problems but the
message changed to "Cannot open any more databases". So I imported the
tables into a test copy of the 2003 front end, and now the message when
printing some of the large complex reports is “cannot open any more tables.â€,
and once I click OK 3 times it goes away.
I expect I will need to rebuild the reports, but if there are any other
options, PLEASE let me know what you think.

 

[Jerry Whittle]

At times like this, nothing beats a good backup. In fact make a complete
backup of your database now and put it away for safe keeping.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

Also make sure to reboot your computer.

 

[Jones]

I had the same problem with a very complex report.

When you Print Preview a report and click Print the database has to reopen
the whole report over again (1 in Print Preview and 1 to send to the
Printer) hence to "Cannot open any more databases" and a whole host of other
error messages.

From code you can use the PrintOut command on the active report OR close the
active report and use the Print command to solve this problem.

 

[Programmer - wannaB]

Thanks Jones, I get the same results when using the direct Print command as I
get from Print preview - Pages after the first 6 or so loose data. So that
is not the answer here.

At this point it looks like I will need to rejoin the data and the front end..
=============================

 

[Programmer - wannaB]

Thanks Jerry, but It is not a corruption issue as the Oh so wise Access
message indicates. I get so much BAD feedback about those generic messages.
I have imported the tables into a copy of the frontend and all worked fine.
The problem is because of the split.
===========================================

 

[Jones]

As a suggestion reports and subreports can only be nested 3 levels deep.

You might also try putting in a dummy subreport or just deleting a subreport
to see how many pages you get.

 

[WANNABE]

That sounds like a great idea, thanks

As a suggestion reports and subreports can only be nested 3 levels deep.

You might also try putting in a dummy subreport or just deleting a subreport
to see how many pages you get.