By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,507 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,507 IT Pros & Developers. It's quick & easy.

Error 3048 Cant Open any more databases

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
How large is the back-end file? Sounds like you may have reached the record
limit.
I'm sure that you've been compacting the data file. To troubleshoot, try
using a copy
of your data, removing a large chunk of records, compacting, then scrolling
your records.
-Ed

"celtic_kiwi" <ga*********@gmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
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

Nov 13 '05 #2

P: 1
I have managed to get error 3048 without code or forms I just use queries and linked tabes. Of course I do use queries which use queries which use queries ... .

Any way of extending the number of table ids would be good

No doubt you have already found: http://www.dbforums.com/t722511.html

I am about to build intermeadiate tables as a means of solving my problem

Chad
Dec 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.