Good afternoon,
I have been building my db on Access 2010 over the last several months and am pretty new to db building. The intent of this project is to audit and report based on those audits. The audit is quite large. It currently has 18 tables. Some with one to one relationships (they were made as one to one as there are not enough fields for the tables to include into one table) and others with one to many. In addition, there are 46 queries and various forms. The problem I am having is with the larger forms (see below).
<tbody>
</tbody>
I am having a couple of problems with this form. I am receiving error codes reserve error -1104 and “Cannot open anymore databases” with error code 3048. After a couple of entries, on my master form dlookup fields turn to #Error. My database is split be and fe. I have tried to merge back to one db and split again. Both options cause the errors. I have decompiled and CompactRepaired the db multiple times without correction. I have done much research, but with my knowledge base, I don’t seem to find a solution. From what I understand, my db is too large and some comments have been made about “loops.” I make sure all the forms are closed with only the one form open. Any of my VBAs are very simple. Can anyone please help me? I do not want to split this into multiple databases to make it work.
I have been building my db on Access 2010 over the last several months and am pretty new to db building. The intent of this project is to audit and report based on those audits. The audit is quite large. It currently has 18 tables. Some with one to one relationships (they were made as one to one as there are not enough fields for the tables to include into one table) and others with one to many. In addition, there are 46 queries and various forms. The problem I am having is with the larger forms (see below).
| Form | Bound Fields | Unbound Fields | Relationship |
| Master | 30 | 4 (dlookup) | Parent |
| Subfrm1 | 134 | 21 | Child1 |
| Subfrm2 | 152 | 39 | Child2 |
| Subfrm2 | 188 | 48 | Child3 |
<tbody>
</tbody>
I am having a couple of problems with this form. I am receiving error codes reserve error -1104 and “Cannot open anymore databases” with error code 3048. After a couple of entries, on my master form dlookup fields turn to #Error. My database is split be and fe. I have tried to merge back to one db and split again. Both options cause the errors. I have decompiled and CompactRepaired the db multiple times without correction. I have done much research, but with my knowledge base, I don’t seem to find a solution. From what I understand, my db is too large and some comments have been made about “loops.” I make sure all the forms are closed with only the one form open. Any of my VBAs are very simple. Can anyone please help me? I do not want to split this into multiple databases to make it work.
