Is there a maximum number of sub-forms allowed in Access 2003?

[TylerTand]

I am working on a database for work and I have one main form named subjects. This form has three sub forms that I have been trying to include. But Access doesn't seem to like it when I have all three and it gives me an error message saying that access has to close down, and it does. I tried to combine two of the subforms into one as a sub-form of a query but it still doesn't seem to like it. I use 2007 at home and of course have no problem having all three subforms. Is this a known issue with 2003? I was hoping someone might know. Thanks for your responses.

 

[KeithG]

Is there any code running when the error message pops up?

 

[The_Doc_Man]

Check the event and application logs (Windows events) to see if you had a machine error, memory error, or other problem at that exact time. These are administrative tools, so if you aren't the machine administrator, you might need help to look at the logs.

 

[boblarson]

And to answer the question about the number of subforms, I have used many more than three in Access 2000 and 2003 and it works great. Also, in 2003 the specifications say that you can have up to 7 nested forms.

 

[TylerTand]

I was in the Form creation process when the error occurs. I don't remember the exact wording but it says that Access has experienced and unexpected error and must close. If I have 2 sub forms things are alright, but when I add the 3rd I get the error. These are government computers so I don't have admin rights and they aren't exactly the fastest machines. Could that have anything to do with it? I have the database on a network as well. Can working on the DB while it is on the network have anything to do with the problem? This is very frustrating since it sounds like others haven't had the same issues. Any other ideas are greatly appreciated. Thanks.

 

[boblarson]

I was in the Form creation process when the error occurs. I don't remember the exact wording but it says that Access has experienced and unexpected error and must close. If I have 2 sub forms things are alright, but when I add the 3rd I get the error. These are government computers so I don't have admin rights and they aren't exactly the fastest machines. Could that have anything to do with it? I have the database on a network as well. Can working on the DB while it is on the network have anything to do with the problem? This is very frustrating since it sounds like others haven't had the same issues. Any other ideas are greatly appreciated. Thanks.

What Operating System are they using and how much RAM do they have?