[ Main | Access | Splitting ]
aka How to speed up complex forms and reports with many records each with subreports.
There are also many other useful tips on speeding up performance at the Microsoft Access Performance FAQ. Many, most or almost all of these are quite applicable after splitting an MDB.
When I split a fairly large combined Access 97 MDB which all the users were
sharing into a FE/BE in Access 97 I found somewhat poorer performance on most
things. More importantly we very poor performance on complex forms which
have lots of combo boxes
and/or subforms as well as reports with subreports.
The downside of this has
happened to me has been that Access 97 has puked on me. Every open form and subform was corrupted. Given that the most complex of these forms was open
at the time on my system I had to re-import older versions of quite a number of
forms. The logic which hides that form now closes the form when it's an
[ Splitting | Access | Main ]
Auto FE Updater distribute new and updated Front End databases to your users with several mouse clicks.
Granite Fleet Manager - the best designed fleet maintenance tracking and management system available