473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Error 3048 Cant Open any more databases

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
2 5594
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Niranjan | last post by:
I have a relatively straight forward report. The query that populates data for this report is complicated. The report opens without any problem and I can print it as well. However, If I have...
0
by: Aaron | last post by:
Hi Guys, I have a dbase installed on a network where the clints have linked tables to the database on the server. I found that i had to make some minor changes to the tables on the server...
1
by: celtic_kiwi | last post by:
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...
0
by: dd_bdlm | last post by:
I have recently updated my database to include a postcode recognition function. And to perform calculations based on that recognised value. The query that makes all these calculations is very large...
2
by: ctyrrell | last post by:
I have read with interest the many discussions of the 3048 Error: Cannot open any more databases. I understand how the number of open Table ID's causes the problem. My question has to do with the...
6
by: mike | last post by:
Failed to update database "D:\INETPUB\WWWROOT\ADROUTER\APP_DATA\ADROUTER.MDF" because the database is read-only. Description: An unhandled exception occurred during the execution of the current...
15
by: David Lozzi | last post by:
Howdy, I have a function that uploads an image and that works great. I love ..Nets built in upload, so much easier than 3rd party uploaders! Now I am making a public function that will take the...
0
by: Lysander | last post by:
Thought I would give something back with a few articles. This article is a bit of code to add error handling. When I have time, I want to write articles on multilingual databases, and Access...
4
by: Chronictank | last post by:
Hi, as a bit of background (and seeing as it is my first post :)) i am a complete newbie at perl. I literally picked it up a week ago to do this project as it seemed like the best choice for a...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.