« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Function mFx() Dim rst as DAO.Recordset Set rst = CurrentDb.OpenRecordset("SomeTableOrQueryName", dbOpenDynaset) ' code ' more code rst.Close ' **** Set rst Blog Articles Threat modeling and root cause correction Where there is a will... Primary Form containing a couple text fields and a TabControl (TC1) TC1 with 3 tabs TC1-Tab1 contains 8 text fields and a subform (sf) (SF1).

Cannot Open Any More Databases Access 2013

mx 0 LVL 75 Overall: Level 75 MS Access 75 Databases 13 Message Active today Expert Comment by:DatabaseMX (Joe Anderson - Access MVP)2010-11-19 Also, although in theory ... In this function, another function is called to count the number of records in the subform based on some criteria. Cannot Open Any More Databases Access 2010 Apr 11 '16 #1 Post Reply Share this Question 4 Replies Expert 100+ P: 354 PhilOfWalton Have a look at Snip. Runtime Error 3048 All product names are trademarks of their respective companies.

But I'm sure I could have done some things more efficiently than I have......but that's always the case. http://bowindex.com/cannot-open/cannot-open-package-error-79.php TableID's are used for the following: - Tables - Queries - Bound forms and reports - Modules for forms and reports - Combo boxes and list boxes whose row source is Without more detail it is difficult to say what the problem is, but unless there are a lot of tables involved in your query, I would have thought that this error Asked another way, how many of those 30 queries are NOT lookup queries?

Phil Apr 11 '16 #2 reply Expert Mod 15k+ P: 29,922 NeoPa Hi Phil. re: suggestions LSM1) I have implemented a solution similar to LSM suggestion re: Single subform which only attaches a source object to the major tab subforms when the tab is active. Please let me know whether it works for you. his comment is here The Access controls themselves are capable of handling the datasets and the overall App performance is acceptable.

The Subform contains several text boxes with one containing a conditional format to color it. The same problems occurred. Regards, Jeffrey We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.

One of the SQL Server objects that you can interact with from within Microsoft Ac… MS Access MS SQL Server Email Servers Advertise Here 738 members asked questions and received personalized

you are going to need to scale back and rethink this design. Have a look at FAQ219-2884 or FAQ181-2886 RE: Runtime error '3048'cannot open anymore databases Trevil (Programmer) 20 Jul 05 16:51 About a year ago, I got involved with an application that Connection Type for split access Database. Cannot Open Any More Databases (Access 2003) chris_lydon asked May 23, 2014 | Replies (15) Hi there I am developing a database in Access 2003 and just recently I have been

Unfortunately, a Contact is a multi-table relationship. JeffCoachman 0 LVL 75 Overall: Level 75 MS Access 75 Databases 13 Message Active today Expert Comment by:DatabaseMX (Joe Anderson - Access MVP)2010-11-19 " I found a few but it A linked query, if it refers to multiple tables, may be using up a lot of table IDs. http://bowindex.com/cannot-open/cannot-open-clipboard-error.php A “connection” includes things like combo boxes, recordsets, queries, etc…..and these add up faster than one might think.

The database is compacted regularly - the front MDB file size is about 7MB, the back end is about 2MB. And sometimes these nested queries contain subqueries further increasing their complexity. We have a thread here on Bytes.com that gives similar help (VBA to change maximum number of locks allowed on a recordset). It's been working great, but I've added a few new employees and now all the sudden when I get to employee #27 I'm getting the error 3048 message: cannot open any

If I set it up so that if only opened once it would show all of the employees in one report. My question would be at what point in the evolution of this db did this issue arrise? 0 Message Author Comment by:cnharrington2010-11-21 A significant change was made 5-6 mos ago This is clearly at the root of my problem. Apr 11 '16 #3 reply P: 55 mshakeelattari This problem is not with a VBA code.

I found a few but it did not cure the problem. 0 LVL 74 Overall: Level 74 MS Access 72 Databases 12 Message Accepted Solution by:Jeffrey Coachman2010-11-19 To me it Handles? I always learn a lot from your posts. You may have to register before you can post: click the register link above to proceed.

Top Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) Yes | No Saving... Hope This Helps.