What can you tell us about the message " Cannot open any more databases"?
I have been using a database at work for a number of years.  Every year we start a new event, the database is copied and all of the tables are emptied.  This year, after taking lots of your tutorials, I decided to split the database.  Now I get that message and I'm thinking that splitting the database was not a good thing.  Is it possible that not splitting the database will cause it to run better?
I've rebuilt three main data entry forms and thought that I fixed it, but when attempt to print a report, I get that message again.
What are your thoughts?

---

Reply from Alex Hedley:

How many tables is it?
Normally this would be if there was a rather large amount. Or linked excel files with complex joins etc.