Database Size Explosion

D

Dozer

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top