Timtropolis
Registered User.
- Local time
- Yesterday, 22:41
- Joined
- Jun 17, 2004
- Messages
- 84
Greetings all,
Have a wierd question that I have not found an answer for so I thought i'd post it here.
I started a new gig and inherited a database. Database was originally created in Access 2003, but was upgraded to 2007 format. Database is split but runs locally on my HD for the time being.
All of the forms are defined as modal. This includes all data entry and search forms. When I tried to open the database and subsequently open forms, it takes forever. On avg, about 10-30 seconds for each form, sometimes longer.
In trying to troubleshoot this problem, I changed the forms to non-modal to see if this would improve performance and it did. All the delays I spoke of disappeared.
So, that being said, does having all the forms set to modal impact database performance? If there is any documentation to this, I'd appreciate a link.
TIA!
Tim
Have a wierd question that I have not found an answer for so I thought i'd post it here.
I started a new gig and inherited a database. Database was originally created in Access 2003, but was upgraded to 2007 format. Database is split but runs locally on my HD for the time being.
All of the forms are defined as modal. This includes all data entry and search forms. When I tried to open the database and subsequently open forms, it takes forever. On avg, about 10-30 seconds for each form, sometimes longer.
In trying to troubleshoot this problem, I changed the forms to non-modal to see if this would improve performance and it did. All the delays I spoke of disappeared.
So, that being said, does having all the forms set to modal impact database performance? If there is any documentation to this, I'd appreciate a link.
TIA!
Tim
