Hello Kathy,
The maximum size for any individual MDB file is: 1 GB for an Access 97
database and 2 GB for Access 2000 and 2002. So, in this case, size does not
matter. Repairing a database 4 times a month would be unacceptable - 4
times a day is well beyond that.
A very common cause for corruption is using a single "monolithic" database
(where forms, reports, queries and modules are stored in the same database
as tables) on the network. A multiuser Access database application should
always be split into a Front-End and a Back-End. The FE contains forms,
reports, queries, modules, macros and however many local tables that might
need to be created in response to individual users' queries. The BE
contains the shared data Tables only. From the FE, you would link to the BE
tables. Most important, each user uses his or her own copy of the FE from
his or her own pc.
You may also want to visit the following link created and maintained by
Access MVP Tony Toews - it may well be the best source available on the
internet on the issue of Access database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm
In addition to the above link, you may also want to review:
http://www.granite.ab.ca/access/splitapp.htm
hth,
