Access File Sizes

tpreece01 | 17:50 Fri 24th Jul 2009 | Computers

2 Answers

I'm doing a bit of research and would like some opinions/discussion on this please.

An Access 97 mdb file is 260mb in size. It contains a number of tables, two queries and nothing else.
4/9 tables (containing 90% of the overall data) are deleted. the queries are also deleted.
The mdb file does not change.

I set up a new database and import the remaining tables into it. The file size is 886kb

The two files now contain exactly the same data, but one is 300 times larger than the other. Why is this?

problem uploading photos

Upgrade RAM

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by tpreece01. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

buzzardweb

You need to compact the database from time to time. In Access 2007 you can set this up to be carried out at close. In AccESS 97 I believe it was done on opening. Go into help and type in "Compact" . It should tell you how to do it.

-- answer removed --

1 to 2 of 2

Do you know the answer?