I have a large MS Access 2003 MDB. The one MDB contains multiple distinct Modules each of which has its own Main Menu form.
In trying to compile it into a MDE it fails on too many open TableIDs for the MS Jet DB Engine V4.0.
What is the best method to overcome this problem? With each Module being quite distinct I could put each Module in a separate MDB / MDE and open them from a MDB / MDE containing the Application Main Menu. If so what code do I use to start them up?
Is there a better way to overcome this problem?