| re: Error 3048: Can't Open any more databases
On 15 Feb 2005 03:37:00 -0800, "celtic_kiwi" <gavin.jolly@gmail.com>
wrote:
You probably have some bad code in either the mainform or a subform. I
suspect the Current event. Perhaps you can post it, and we may be able
to spot the problem.
-Tom.
[color=blue]
>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[/color]
| 
