I have been having issues with 8 or so forms open concurrently and running into error 3048 in Access 2003.
I have been doing some research into error 3048 in access. Access cannot open any more databases and have found out about the 2048 concurrently open table handle limit.
I'm also aware that having a seperate FE and BE split doubles or triples the amount of open handles required, and do have a split FE and BE. I have had some luck in reducing this error message by tidying up code and closing any open references and by using closing and dereferencing objects.
One thing which i havn't been able to find out is if a combo box which has a query / table for its rowsource , does it require a seperate table connections / handles for each record the combo box is shown for ? or only once for the form the combo box is on ? If i knew this then i would know if its worthwhile to reduce the amount of combo boxes used.
As another part to this question is, as i undestand there is no way to accurately measure how many table handles are been used at any one time , short of duplicating the form and estimating that way. Is there a better way to monitor how many table handles have been used ?