database size problems

  • Thread starter Thread starter kathy
  • Start date Start date
K

kathy

I have a large database which needs repaired about 4 times
a day. Is there any guideline for Access database size
limitations? This one is currently about 153 MB.

Could there be another problem. This is our Master tables
for all of our data and I cannot risk losing it.
 
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,
 
Back
Top