I am pleased to report that I have been able to achieve a significant improvement in the number of form instances that my application can load before Microsoft Access generates error 3048 "Cannot open any more databases". Allen Browne's suggestions were of great help. Essentially I created a generic routine to load combobox and some listbox RowSources as Value Lists rather than Queries.
Partick, I'm not privy to what goes on inside Access at that level. I can tell you that there are bugs where Access fails to release connections. If you're serious about tracking that down, here's an example where that is the case: http://allenbrowne.com/temp/FreeConnectionBug.zip -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
************************************************************** JobCircle.com is a regional job board serving all industries and occupations in the PA, NJ, DE, NY, MD, and DC areas. We offer a regional job board, online learning, and regional job fair events for jobseekers who live in our areas of focus. To Learn More: Job Board: http://www.JobCircle.com?source=ng eLearning
