I have an Access DB that grows as the users use it. It
starts out at 8000 kb and then grows to 111,000kb by the
afternoon. I compact and repair, but I do not understand
what is causing this. Please help!
A few questions:
- Is this a split database? or a single database containing tables,
forms, etc. shared by all users? If the latter, you should certainly
use the Database Splitter Wizard to split it into a "backend", a
shared database containing only the tables; and a "frontend", which
contains links to the tables and all the forms, queries, reports and
so on. Each user should have their own copy of the frontend.
- Do you make much use of MakeTable queries, temp tables, etc.? If so,
note that deleting records (or tables) does NOT free up the space that
they occupied. Tony Toews (
http://www.granite.ab.ca/access) has some
hints for using a separate backend database for temp tables.
John W. Vinson[MVP]
(no longer chatting for now)
