Hi Dick,
Database applications are not like furniture--one doesn't clean them
periodically. Have you compacted the application lately? This is done using
Tools > Database Utilities > Compact and repair database. If this is a
multiuser application, then hopefully your developer created what is known as
a split application (split into two files: a front-end (FE) and a back-end
(BE) file). A copy of the FE should be installed on each user's hard drive.
Both file types (FE & BE) should be compacted regularly, although, in
practice, an updated (and pre-compacted) copy of the FE is often distributed
by a developer, before users actually need to compact their copies. The BE is
compacted separately from the FE.
If the application is designed properly, it is *not* opening bound forms to
hundreds of thousands of records. However, all too often, this is exactly the
design that a novice developer will create. So, without knowing anything
about the design of your application, or the skill level of the person who
developed it, it's kind of hard to provide much guidance. But, if you have
forms that open huge recordsets, that's usually not a good sign. If this is
the case, then perhaps you should make a copy of the database for archival
purposes, and then delete older records if they are not needed. Then compact
the database.
Perhaps this paper will be helpful for you:
Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
