craigachan
Registered User.
- Local time
- Today, 12:25
- Joined
- Nov 9, 2007
- Messages
- 282
I'm hoping someone has some knowledge of this issue. I have an FE and BE. Each workstation (the max using the front end is 3 persons) has the FE on their computer in \documents. My BE is on a server and has 2 databases that the FEs link to. ( I use alot of temptables when possible) one that we work with day to day(655mb), and one that we use for archiving (288mb). My application is still a work in progress after 17 years. We're always adding to it.
A few days ago I started to get a Runtime 3084 - 'Cannot open any more databases". After doing my online search, I went back to rewrite my vba and have started to replace all of my DLookups with a records set, and making sure I open, closed and set the recordset to nothing. I have so far redone my Public Functions and my opening form. There was quite a bit to correct. One thing to note, from the time my app was working well to when the error started up, I know I didn't add too much database function, maybe 1 open recordset, but not more. And one would think after correcting at least 30 or more DLookups, it would have improved and at least gotten back to normal. None of my corrections seemed to improve anything and I still got the error.
I then started to check the open and close of Access. I noticed that Access didn't close all the way. At first I thought it wouldn't close correctly because of the error. So I tried to simply open the application, and then, without clicking anything on my application, and also not getting to the point of the error, close it. What I found was that the visual part of the application would close most of the time, but the laccdb file would not clear. I could only clear the laccdb if I first went to task manager and manually end the MSAccess still running.
I next tried to open my application in design mode using the shift button. Compacted/Repaired, Compiled, and then closed the app. This did not help at all. I have check my ram and upped it all the way to 2909mb just to see what would happen. But no improvements were noted.
My application is a healthcare application, and currently I can open it to the opening form without problems. I can click up to 15 patient records before the error appears.
Additionally, I repaired the Office 365 Application.
I'm not sure what do to next. I would be happy to post my related code if needed. I don't fully understand everything that adds to the number of databases that can open. So any help on these functions will help me. Otherwise I'm not sure what else to do. I will appreciate any help and insight on this.
A few days ago I started to get a Runtime 3084 - 'Cannot open any more databases". After doing my online search, I went back to rewrite my vba and have started to replace all of my DLookups with a records set, and making sure I open, closed and set the recordset to nothing. I have so far redone my Public Functions and my opening form. There was quite a bit to correct. One thing to note, from the time my app was working well to when the error started up, I know I didn't add too much database function, maybe 1 open recordset, but not more. And one would think after correcting at least 30 or more DLookups, it would have improved and at least gotten back to normal. None of my corrections seemed to improve anything and I still got the error.
I then started to check the open and close of Access. I noticed that Access didn't close all the way. At first I thought it wouldn't close correctly because of the error. So I tried to simply open the application, and then, without clicking anything on my application, and also not getting to the point of the error, close it. What I found was that the visual part of the application would close most of the time, but the laccdb file would not clear. I could only clear the laccdb if I first went to task manager and manually end the MSAccess still running.
I next tried to open my application in design mode using the shift button. Compacted/Repaired, Compiled, and then closed the app. This did not help at all. I have check my ram and upped it all the way to 2909mb just to see what would happen. But no improvements were noted.
My application is a healthcare application, and currently I can open it to the opening form without problems. I can click up to 15 patient records before the error appears.
Additionally, I repaired the Office 365 Application.
I'm not sure what do to next. I would be happy to post my related code if needed. I don't fully understand everything that adds to the number of databases that can open. So any help on these functions will help me. Otherwise I'm not sure what else to do. I will appreciate any help and insight on this.
Last edited:
