Repost - Database size explosion

  • Thread starter Thread starter Dozer
  • Start date Start date
D

Dozer

{originally posted on February 15 - no responses}

Hi

I have Access XP and Win 2000.

My database is just under construction. At the moment it
has 7 tables, 1 query and 1 form. I think the problem is
with the form but I am not sure.

When I compact and repair, the database size is about
6MB...seems large but OK. If I do any design work with the
form it can blow up to 100+ MB. Changing the font colours
can make this kind of thing happen.

The record source for the form is a query that gets it's
data from all of the tables. There are 140+ fields in
total and a few calculations. Is the recalculation the
problem?

I have not had this happen with Access 2K so I am
wondering if this is an XP thing.

Thanks!
 
Hi

Maybe you could try the Decompile function. This may alleviate some of the
problems you are encountering.

Maurice



1. Create a backup copy of the MDB file while Access is not running.

2. Decompile the database by entering something like this at the command
prompt (one line, including the quotes):
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\My Documents\MyDatabase.mdb"

3. When the database opens: Tools | Database Utilities | Compact.

==============================
 
Back
Top