I have an Access 97 database, quite large, and have started getting the
error, Error 3048: Can't Open any more databases.
-The data is split from the application (front end and back end).
-The application has a fair bit of VBA
-The Data database resides on a network server
-Generally there are 3-4 front-ends attached at any one time
The application has run happily in its current state, aside from
incremental changes, for over 5 years. I did make some changes around
the time it started but cant seem to relate any of these to this issue.
I can replicate the error every time by scrolling through 75 records in
the main form. This form has 4 subforms. 3 are lightweight but one is a
continuous form with multiple combo boxes. It has had exactly the same
structure for the last 4 years.
As potential solutions
-I have looked through the application looking for CurrentDB() objects
not ended.
-I have updated the version of MSJET to 3.5SP3.
-There are no missing References.
-I copied the backend and frontend to my laptop and was able to
replicate the same error at the 75th record.
-I went directly to the 75th record and moved back and forth through
the forms records from around 70 to 80. The error occurred once the
75th record had been scrolled to. Therefore there is nothing special
about the 75th record.
Is there any way I can determine what the open database connections are
using VBA or some addin.
If anyone can help I would greatly appreciate it as I will start
looking like an idiot if I cannot solve this issue.
TIA
Celtic_Kiwi